APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_MEL_CDL_ATA_SEQUENCES

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 1324: from ahl_mel_cdl_ata_sequences seq, ahl_mel_cdl_headers hdr,

1320: -- get mel/cdl details.
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

Line 1339: AHL_MEL_CDL_ATA_SEQUENCES SEQ

1335: is
1336: select count(ue.cs_incident_id)
1337: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1338: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1339: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1340: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1341: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1342: AND UE.CS_INCIDENT_ID = CS.INCIDENT_ID
1343: AND CS.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID

Line 1832: --AHL_MEL_CDL_ATA_SEQUENCES SEQ

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
1835: --AND
1836: UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID

Line 1852: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR

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
1855: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1856: AND UE.CS_INCIDENT_ID = CS.INCIDENT_ID

Line 2718: FROM ahl_mel_cdl_ata_sequences

2714: p_ata_code varchar2
2715: )
2716: IS
2717: SELECT mel_cdl_ata_sequence_id
2718: FROM ahl_mel_cdl_ata_sequences
2719: WHERE mel_cdl_header_id = p_mel_cdl_header_id and
2720: ata_code = p_ata_code;
2721:
2722: CURSOR get_ata_for_position

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.