SQL & PL/SQL

Hi Guys

I have a public SYNONYM that was created to access a table on the remote database using a DB Link.

We are able to access the DB Link using SQL Plus and the Synonym BUT when the same is used inside the cursor query of a PL/SQL block we get the following error message!

This is driving me crazy... need your expert suggestion :)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Errors for PROCEDURE SP_PROCESS_SESEBA031:

59/12 PLS-00341: declaration of cursor 'V_CUR' is incomplete or
malformed

60/9 PL/SQL: ORA-01775: looping chain of synonyms
60/9 PL/SQL: SQL Statement ignored
95/15 PL/SQL: Item ignored
123/9 PL/SQL: SQL Statement ignored
124/18 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

127/9 PL/SQL: Statement ignored
127/12 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

148/13 PL/SQL: SQL Statement ignored
161/37 PL/SQL: ORA-00904: "V_DTL_REC"."TRADE_DATE": invalid identifier
161/37 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

180/9 PL/SQL: Statement ignored
180/53 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

182/9 PL/SQL: SQL Statement ignored
213/14 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

213/24 PL/SQL: ORA-00984: column not allowed here
Compile source: /usctreg1/app/db/proc/SP_PROCESS_SESECRC.src
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks & Best Regards,
Faisal.