APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on AHL_UE_RELATIONSHIPS

Line 401: ahl_ue_relationships uer

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