DBA Data[Home] [Help]

APPS.AHL_EAM_JOB_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 143: AHL_UNIT_EFFECTIVITIES_B UE

139: IS
140: SELECT
141: cs_incident_id, nvl(manually_planned_flag,'N')
142: FROM
143: AHL_UNIT_EFFECTIVITIES_B UE
144: WHERE
145: UE.unit_effectivity_id = p_ue_id
146: AND NOT EXISTS (SELECT 'x'
147: FROM AHL_UE_RELATIONSHIPS UER

Line 157: AHL_UNIT_EFFECTIVITIES_B UE

153: IS
154: SELECT
155: cs_incident_id, nvl(manually_planned_flag,'N')
156: FROM
157: AHL_UNIT_EFFECTIVITIES_B UE
158: WHERE
159: UE.unit_effectivity_id IN (SELECT originator_ue_id
160: FROM AHL_UE_RELATIONSHIPS UER
161: WHERE UER.related_ue_id = p_ue_id