APPS.CSF_WF_EVENT_SUBSCR_PKG dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 87: ahl_unit_effectivities_vl aueb,

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
91: and cil.object_type = 'AHL_UMP_EFF'

Line 100: ahl_unit_effectivities_vl aueb,

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
104: or aueb.status_code = 'INIT-DUE')