APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_REPAIR_CATEGORIES

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 1242: ahl_repair_categories rc

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
1246: and seq.repair_category_id = rc.repair_category_id;

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.