SELECT * FROM DBA_OBJECTS WHERE OBJECT_NAME = 'PRC_EOD_PROCESSING' ;

OWNER	OBJECT_NAME	      SUBOBJECT_NAME	OBJECT_ID  DATA_OBJECT_ID   OBJECT_TYPE	 CREATED
COMN	PRC_EOD_PROCESSING	                83531	   PROCEDURE	                 03-09-2013 11:58:26
APPL	PRC_EOD_PROCESSING	                83644	   SYNONYM	                 04-09-2013 15:10:44


LAST_DDL_TIME	        TIMESTAMP	        STATUS	TEMPORARY  GENERATED  SECONDARY	NAMESPACE  EDITION_NAME
18-10-2013 17:51:17	2013-10-18:17:51:17	VALID	N	   N	      N	        1	
22-10-2013 11:04:17	2013-10-22:11:04:17	VALID	N	   N	      N	        1	

SELECT * FROM DBA_TAB_PRIVS WHERE TABLE_NAME = 'PRC_EOD_PROCESSING' ;

GRANTEE	OWNER	TABLE_NAME	        GRANTOR	PRIVILEGE	GRANTABLE	HIERARCHY
APPL	COMN	PRC_EOD_PROCESSING	COMN	EXECUTE	        NO	        NO
APPL	COMN	PRC_EOD_PROCESSING	COMN	DEBUG	        NO	        NO

ORA-06550: line 1, column 7:
PLS-00201: identifier 'PRC_EOD_PROCESSING' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

CREATE OR REPLACE SYNONYM PRC_EOD_PROCESSING FOR COMN.PRC_EOD_PROCESSING ;

SQL> create user u1 identified by u1;

User created.

SQL> create user u2 identified by u2;

User created.

SQL> grant create session, create synonym to u2;

Grant succeeded.

SQL> create or replace procedure u1.p is begin dbms_output.put_line('In U1.P'); end;
  2  /

Procedure created.

SQL> grant execute on u1.p to u2;

Grant succeeded.

SQL> connect u2/u2
Connected.
U2> exec u1.p;
In U1.P

PL/SQL procedure successfully completed.

U2> create synonym p for u1.p;

Synonym created.

U2> exec p;
In U1.P

PL/SQL procedure successfully completed.

ORA-06550: line 1, column 7:
PLS-00201: identifier 'PRC_EOD_PROCESSING' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored