APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on ASG_PUB_ITEM

Line 1770: from csm_deferred_nfn_info nfn , asg_pub_item pi, asg_user usr, wf_roles wfrl

1766: CURSOR c_get_deferred_data(b_id NUMBER)
1767: IS
1768: select nfn.deferred_tran_id,nfn.sequence, nfn.client_id, DECODE(NVL(usr.multi_platform,'N'),'Y','WEBKIT-Based',NVL(usr.cookie,'WINCE')) as DEVICE_TYPE,
1769: wfrl.display_name, nfn.object_name, pi.primary_key_column, nfn.object_id, nfn.error_msg,nfn.creation_date
1770: from csm_deferred_nfn_info nfn , asg_pub_item pi, asg_user usr, wf_roles wfrl
1771: where tracking_id=b_id
1772: and wfrl.name=nfn.client_id
1773: and nfn.object_name=pi.item_id
1774: and usr.user_name=nfn.client_id;

Line 2006: FROM ASG_PUB_ITEM

2002: END IF;
2003:
2004:
2005: SELECT primary_key_column INTO l_pk_col
2006: FROM ASG_PUB_ITEM
2007: WHERE item_id=p_pubitem;
2008:
2009: IF instr(l_pk_col,',')<> 0 THEN
2010: CSM_UTIL_PKG.LOG('Mulitple Pks in '||p_pubitem||' is not supported in MFS Updatable PIs',