DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_HEADERS_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 1090: FROM ahl_mel_cdl_mo_procedures mo, ahl_mr_headers_app_v mrh

1086: mo.attribute12,
1087: mo.attribute13,
1088: mo.attribute14,
1089: mo.attribute15
1090: FROM ahl_mel_cdl_mo_procedures mo, ahl_mr_headers_app_v mrh
1091: WHERE mo.mr_header_id = mrh.mr_header_id and
1092: mrh.mr_status_code = 'COMPLETE' and
1093: trunc(sysdate) between trunc(mrh.effective_from) and trunc(nvl(effective_to, sysdate + 1)) and
1094: mo.ata_sequence_id = p_ata_sequence_id;