APPS.CSF_WF_EVENT_SUBSCR_PKG dependencies on CS_INCIDENT_LINKS

Line 88: cs_incident_links cil

84: aueb.forecast_sequence, aueb.mr_header_id
85: FROM
86: cs_incidents_all_b csi,
87: ahl_unit_effectivities_vl aueb,
88: cs_incident_links cil
89: WHERE
90: cil.object_id = aueb.unit_effectivity_id
91: and cil.object_type = 'AHL_UMP_EFF'
92: and cil.link_type_id = 6

Line 101: cs_incident_links cil

97: CURSOR c_check_for_pm_sr_csr IS
98: SELECT csi.incident_id,aueb.unit_effectivity_id from
99: cs_incidents_all_b csi,
100: ahl_unit_effectivities_vl aueb,
101: cs_incident_links cil
102: WHERE
103: (aueb.status_code is NULL
104: or aueb.status_code = 'INIT-DUE')
105: and cil.object_id = aueb.unit_effectivity_id