APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 1094: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,

1090: 'HZ_LOCATION',
1091: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1092: ) location_id
1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1094: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1095: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1096: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1097: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id
1098: AND b.TASK_ID=tsk.TASK_ID

Line 1122: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,

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
1126: AND au.USER_ID=acc.USER_ID

Line 1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,

1175: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1176: 'HZ_LOCATION',
1177: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1178: ) location_id
1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,
1180: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1181: WHERE acc.incident_id=b_inc_id
1182: AND au.USER_ID=acc.USER_ID
1183: AND INC.incident_id=acc.incident_id