APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 1830: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,

1826: -- modified for perf fix bug# 7442102
1827: CURSOR nr_mel_cdl_csr(p_mel_cdl_header_id IN NUMBER) IS
1828: SELECT UE.unit_effectivity_id
1829: FROM
1830: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1831: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,
1832: --AHL_MEL_CDL_ATA_SEQUENCES SEQ
1833: WHERE
1834: --SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID

Line 1850: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,

1846: -- query to check existence of open NRs for a pc_node_id.
1847: CURSOR nr_pc_node_csr(p_pc_node_id IN NUMBER) IS
1848: SELECT UE.unit_effectivity_id
1849: FROM
1850: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1851: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1852: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR
1853: WHERE
1854: SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID