APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 1314: from ahl_ue_relationships

1310: is
1311: select 'x'
1312: from ahl_unit_deferrals_b
1313: where unit_effectivity_id IN (select related_ue_id
1314: from ahl_ue_relationships
1315: start with ue_id = p_ue_id
1316: connect by PRIOR related_ue_id = ue_id)
1317: and unit_deferral_type = 'DEFERRAL'
1318: and approval_status_code = 'DEFERRAL_PENDING';