APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on AHL_MEL_CDL_HEADERS

Line 64: ahl_mel_cdl_headers hdr

60: SELECT
61: hdr.status_code
62: FROM
63: ahl_mel_cdl_ata_sequences ata,
64: ahl_mel_cdl_headers hdr
65: WHERE
66: mel_cdl_ata_sequence_id = ata_seq_id
67: AND ata.mel_cdl_header_id = hdr. mel_cdl_header_id;
68:

Line 2016: FROM ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata

2012:
2013: CURSOR get_ata_mel_cdl_status
2014: IS
2015: SELECT hdr.status_code, hdr.mel_cdl_header_id
2016: FROM ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata
2017: WHERE hdr.mel_cdl_header_id = ata.mel_cdl_header_id AND
2018: ata.mel_cdl_ata_sequence_id = p_ata_sequence_id;
2019:
2020: CURSOR get_mel_cdl_status

Line 2023: FROM ahl_mel_cdl_headers

2019:
2020: CURSOR get_mel_cdl_status
2021: IS
2022: SELECT status_code, mel_cdl_header_id
2023: FROM ahl_mel_cdl_headers
2024: WHERE mel_cdl_header_id = p_mel_cdl_header_id;
2025:
2026: l_status VARCHAR2(30);
2027: l_mel_cdl_header_id NUMBER;

Line 2055: UPDATE ahl_mel_cdl_headers

2051: FND_MSG_PUB.ADD;
2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF (l_status = 'APPROVAL_REJECTED')
2054: THEN
2055: UPDATE ahl_mel_cdl_headers
2056: SET status_code = 'DRAFT'
2057: WHERE mel_cdl_header_id = l_mel_cdl_header_id;
2058: END IF;
2059: END Check_Mel_Cdl_Status;