APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_MEL_CDL_ATA_SEQUENCES

Line 375: FROM ahl_mel_cdl_ata_sequences ata, ahl_repair_categories repcat

371: THEN
372: -- Bug #5230869 - validate inc_occ_date + rep_time >= inc_date
373: SELECT repcat.repair_time
374: INTO l_ata_rep_time
375: FROM ahl_mel_cdl_ata_sequences ata, ahl_repair_categories repcat
376: WHERE ata.repair_category_id = repcat.repair_category_id and ata.mel_cdl_ata_sequence_id = l_ata_sequence_id;
377:
378: IF (NVL(l_ata_rep_time, 0) <> 0 AND trunc(l_service_request_rec.incident_occurred_date) + trunc(l_ata_rep_time/24) < trunc(l_service_request_rec.request_date))
379: THEN

Line 905: FROM ahl_mel_cdl_ata_sequences ata, ahl_repair_categories repcat

901: THEN
902: -- Bug #5230869 - validate inc_occ_date + rep_time >= inc_date
903: SELECT repcat.repair_time
904: INTO l_ata_rep_time
905: FROM ahl_mel_cdl_ata_sequences ata, ahl_repair_categories repcat
906: WHERE ata.repair_category_id = repcat.repair_category_id and ata.mel_cdl_ata_sequence_id = l_ata_sequence_id;
907:
908: IF (NVL(l_ata_rep_time, 0) <> 0 AND trunc(l_service_request_rec.incident_occurred_date) + trunc(l_ata_rep_time/24) < trunc(l_service_request_rec.request_date))
909: THEN

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 1256: AHL_MEL_CDL_ATA_SEQUENCES SEQ

1252: is
1253: select count(ue.cs_incident_id)
1254: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1255: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1256: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1257: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1258: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1259: AND UE.CS_INCIDENT_ID = CS.INCIDENT_ID
1260: AND CS.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID

Line 1744: --AHL_MEL_CDL_ATA_SEQUENCES SEQ

1740: SELECT UE.unit_effectivity_id
1741: FROM
1742: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1743: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,
1744: --AHL_MEL_CDL_ATA_SEQUENCES SEQ
1745: WHERE
1746: --SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1747: --AND
1748: UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID

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 2624: FROM ahl_mel_cdl_ata_sequences

2620: p_ata_code varchar2
2621: )
2622: IS
2623: SELECT mel_cdl_ata_sequence_id
2624: FROM ahl_mel_cdl_ata_sequences
2625: WHERE mel_cdl_header_id = p_mel_cdl_header_id and
2626: ata_code = p_ata_code;
2627:
2628: CURSOR get_ata_for_position

Line 3269: from ahl_mel_cdl_ata_sequences seq, ahl_repair_categories rep

3265: -- get urgency for the ata sequence.
3266: CURSOR get_urgency_details_csr (p_ata_sequence_id IN NUMBER)
3267: is
3268: select repair_time, sr_urgency_id
3269: from ahl_mel_cdl_ata_sequences seq, ahl_repair_categories rep
3270: where mel_cdl_ata_sequence_id = p_ata_sequence_id
3271: and seq.repair_category_id = rep.repair_category_id;
3272:
3273: -- get deferral details.