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
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