APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on AHL_UE_RELATIONSHIPS

Line 399: ahl_ue_relationships uer

395: CURSOR c_cmro_orders IS
396: SELECT ue.mr_header_id
397: FROM ahl_unit_effectivities_app_v sr_ue,
398: ahl_unit_effectivities_app_v ue,
399: ahl_ue_relationships uer
400: WHERE sr_ue.unit_effectivity_id = uer.ue_id
401: and uer.related_ue_id = ue.unit_effectivity_id
402: and sr_ue.cs_incident_id = p_service_request_id;
403: CURSOR c_obj_ver_num IS