APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on WF_ROLES

Line 424: /*12.1.2 PURGE INACTIVE CSM WF ROLES*/

420: END LOOP;
421:
422: COMMIT;
423:
424: /*12.1.2 PURGE INACTIVE CSM WF ROLES*/
425: DELETE FROM WF_LOCAL_ROLES B WHERE NAME LIKE 'CSM%ROLE'
426: AND NOT EXISTS( SELECT 1 FROM FND_USER U
427: WHERE USER_NAME=substr(B.NAME,5,length(B.NAME)-9)
428: AND sysdate between nvl(start_date,sysdate-1) and nvl(end_date,sysdate+1));

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;