APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_MEL_CDL_HEADERS

Line 1241: from ahl_mel_cdl_ata_sequences seq, ahl_mel_cdl_headers hdr,

1237: -- get mel/cdl details.
1238: cursor mel_cdl_header_csr (p_ata_sequence_id IN NUMBER)
1239: is
1240: select seq.INSTALLED_NUMBER, seq.DISPATCH_NUMBER, nvl(rc.repair_time,0)
1241: from ahl_mel_cdl_ata_sequences seq, ahl_mel_cdl_headers hdr,
1242: ahl_repair_categories rc
1243: where seq.mel_cdl_header_id = hdr.mel_cdl_header_id
1244: and seq.mel_cdl_ata_sequence_id = p_ata_sequence_id
1245: and nvl(hdr.expired_date, sysdate+1) > sysdate

Line 1764: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR

1760: SELECT UE.unit_effectivity_id
1761: FROM
1762: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1763: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1764: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR
1765: WHERE
1766: SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1767: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1768: AND UE.CS_INCIDENT_ID = CS.INCIDENT_ID

Line 1891: ahl_mel_cdl_headers mel

1887: )
1888: IS
1889: select mel.mel_cdl_header_id, mel.version_number, pcn.pc_node_id
1890: from ahl_pc_nodes_b pcn,
1891: ahl_mel_cdl_headers mel
1892: --where pcn.pc_node_id = mel.pc_node_id (+) and -- perf fix for bug# 7442102
1893: where pcn.pc_node_id = mel.pc_node_id and
1894: mel.mel_cdl_type_code = l_mel_cdl_type_code and
1895: mel.status_code = 'COMPLETE' and