APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on ASG_SYSTEM_DIRTY_QUEUE

Line 975: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,

971: CURSOR c_sr(b_sr_id NUMBER,b_user_id NUMBER)
972: IS
973: SELECT 1
974: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
975: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,
976: jtf_tasks_b tsk
977: where tsk.source_object_id=b_sr_id
978: and tsk.source_object_type_code='SR'
979: and tsk.task_id=asg.task_id

Line 1000: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc

996:
997: CURSOR c_task(b_task_id NUMBER,b_user_id NUMBER) IS
998: SELECT 1
999: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
1000: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc
1001: where task_id=b_task_id
1002: and (
1003: (nfn.object_name='TASK' and nfn.object_id=task_id)
1004: OR

Line 1021: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,

1017:
1018: CURSOR c_task_asg(b_task_ass_id NUMBER,b_user_id NUMBER) IS
1019: SELECT 1
1020: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
1021: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,
1022: jtf_tasks_b tsk
1023: where task_assignment_id=b_task_ass_id
1024: and tsk.task_id=asg.task_id
1025: and nfn.object_name='TASK_ASSIGNMENT' and nfn.object_id=task_assignment_id