APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 1231: from ahl_ue_relationships

1227: is
1228: select 'x'
1229: from ahl_unit_deferrals_b
1230: where unit_effectivity_id IN (select related_ue_id
1231: from ahl_ue_relationships
1232: start with ue_id = p_ue_id
1233: connect by PRIOR related_ue_id = ue_id)
1234: and unit_deferral_type = 'DEFERRAL'
1235: and approval_status_code = 'DEFERRAL_PENDING';