APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_REPAIR_CATEGORIES

Line 407: FROM ahl_mel_cdl_ata_sequences ata, ahl_repair_categories repcat

403: THEN
404: -- Bug #5230869 - validate inc_occ_date + rep_time >= inc_date
405: SELECT repcat.repair_time
406: INTO l_ata_rep_time
407: FROM ahl_mel_cdl_ata_sequences ata, ahl_repair_categories repcat
408: WHERE ata.repair_category_id = repcat.repair_category_id and ata.mel_cdl_ata_sequence_id = l_ata_sequence_id;
409:
410: 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))
411: THEN

Line 986: FROM ahl_mel_cdl_ata_sequences ata, ahl_repair_categories repcat

982: THEN
983: -- Bug #5230869 - validate inc_occ_date + rep_time >= inc_date
984: SELECT repcat.repair_time
985: INTO l_ata_rep_time
986: FROM ahl_mel_cdl_ata_sequences ata, ahl_repair_categories repcat
987: WHERE ata.repair_category_id = repcat.repair_category_id and ata.mel_cdl_ata_sequence_id = l_ata_sequence_id;
988:
989: 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))
990: THEN

Line 1325: ahl_repair_categories rc

1321: cursor mel_cdl_header_csr (p_ata_sequence_id IN NUMBER)
1322: is
1323: select seq.INSTALLED_NUMBER, seq.DISPATCH_NUMBER, nvl(rc.repair_time,0)
1324: from ahl_mel_cdl_ata_sequences seq, ahl_mel_cdl_headers hdr,
1325: ahl_repair_categories rc
1326: where seq.mel_cdl_header_id = hdr.mel_cdl_header_id
1327: and seq.mel_cdl_ata_sequence_id = p_ata_sequence_id
1328: and nvl(hdr.expired_date, sysdate+1) > sysdate
1329: and seq.repair_category_id = rc.repair_category_id;

Line 3442: from ahl_mel_cdl_ata_sequences seq, ahl_repair_categories rep

3438: -- get urgency for the ata sequence.
3439: CURSOR get_urgency_details_csr (p_ata_sequence_id IN NUMBER)
3440: is
3441: select repair_time, sr_urgency_id
3442: from ahl_mel_cdl_ata_sequences seq, ahl_repair_categories rep
3443: where mel_cdl_ata_sequence_id = p_ata_sequence_id
3444: and seq.repair_category_id = rep.repair_category_id;
3445:
3446: -- get deferral details.