APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_MEL_CDL_MO_PROCEDURES

Line 3411: FROM ahl_mel_cdl_mo_procedures mop,

3407: -- pdoki modified for Bug 10312082
3408: cursor mo_procedures_csr (p_ata_sequence_id IN NUMBER)
3409: is
3410: SELECT mop.mr_header_id
3411: FROM ahl_mel_cdl_mo_procedures mop,
3412: ahl_mr_headers_b mrh
3413: WHERE mop.ata_sequence_id = p_ata_sequence_id
3414: AND mrh.mr_header_id = mop.mr_header_id
3415: AND mrh.mr_status_code = 'COMPLETE'