APPS.CSM_DEFERRED_TXNS_PKG dependencies on ASG_PUB_ITEM

Line 26: FROM CSM_DEFERRED_NFN_INFO nfn, ASG_PUB_ITEM pi

22: BEGIN
23: SELECT nfn.DEFERRED_TRAN_ID,nfn.CLIENT_ID, nfn.SEQUENCE,nfn.DML,
24: nfn.OBJECT_NAME,pi.PRIMARY_KEY_COLUMN,nfn.OBJECT_ID,instr(pi.PRIMARY_KEY_COLUMN,',')
25: INTO old_tranid, old_client_id,old_seq,old_dml,inq_table,inq_pk_col,inq_pk_value,l_proceed
26: FROM CSM_DEFERRED_NFN_INFO nfn, ASG_PUB_ITEM pi
27: WHERE nfn.tracking_id=p_tracking_id
28: AND nfn.OBJECT_NAME = pi.item_id;
29:
30: IF l_proceed > 0 THEN