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 2010: FROM ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata

2006:
2007: CURSOR get_ata_mel_cdl_status
2008: IS
2009: SELECT hdr.status_code, hdr.mel_cdl_header_id
2010: FROM ahl_mel_cdl_headers hdr, ahl_mel_cdl_ata_sequences ata
2011: WHERE hdr.mel_cdl_header_id = ata.mel_cdl_header_id AND
2012: ata.mel_cdl_ata_sequence_id = p_ata_sequence_id;
2013:
2014: CURSOR get_mel_cdl_status

Line 2017: FROM ahl_mel_cdl_headers

2013:
2014: CURSOR get_mel_cdl_status
2015: IS
2016: SELECT status_code, mel_cdl_header_id
2017: FROM ahl_mel_cdl_headers
2018: WHERE mel_cdl_header_id = p_mel_cdl_header_id;
2019:
2020: l_status VARCHAR2(30);
2021: l_mel_cdl_header_id NUMBER;

Line 2049: UPDATE ahl_mel_cdl_headers

2045: FND_MSG_PUB.ADD;
2046: RAISE FND_API.G_EXC_ERROR;
2047: ELSIF (l_status = 'APPROVAL_REJECTED')
2048: THEN
2049: UPDATE ahl_mel_cdl_headers
2050: SET status_code = 'DRAFT'
2051: WHERE mel_cdl_header_id = l_mel_cdl_header_id;
2052: END IF;
2053: END Check_Mel_Cdl_Status;