DBA Data[Home] [Help]

APPS.CSF_WF_EVENT_SUBSCR_PKG dependencies on CS_INCIDENTS_ALL_B

Line 86: cs_incidents_all_b csi,

82: CURSOR c_get_ue_details_csr IS
83: SELECT csi.incident_id, csi.customer_product_id,
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

Line 99: cs_incidents_all_b csi,

95:
96:
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