DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_TASKS_ACC

Line 1121: FROM ASG_USER AU, CSM_TASKS_ACC ACC,

1117: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1118: 'HZ_LOCATION',
1119: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1120: ) location_id
1121: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1122: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1123: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1124: WHERE acc.TASK_ID=b_task_id
1125: AND acc.TASK_ID=tsk.TASK_ID

Line 1142: FROM ASG_USER AU, CSM_TASKS_ACC ACC,

1138: CURSOR c_user_task2(b_task_id NUMBER)
1139: IS
1140: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, acc.TASK_ID,TASK_NAME,TASK_NUMBER,
1141: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1142: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1143: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1144: WHERE acc.TASK_ID=b_task_id
1145: AND acc.TASK_ID=tsk.TASK_ID
1146: AND au.USER_ID=acc.USER_ID