APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on AHL_MR_HEADERS_B

Line 873: ahl_mr_headers_b

869: )
870: IS
871: SELECT 'x'
872: FROM
873: ahl_mr_headers_b
874: WHERE
875: mr_header_id = mr_header_id
876: and upper(program_type_code) = upper('MO_PROC');
877: --and upper(mr_status_code) = upper('COMPLETE')

Line 889: ahl_mr_headers_b

885: )
886: IS
887: SELECT mr_status_code
888: FROM
889: ahl_mr_headers_b
890: WHERE
891: mr_header_id = mr_header_id
892: --and upper(program_type_code) = upper('MO_PROC')
893: and upper(mr_status_code) = upper('COMPLETE')

Line 906: ahl_mr_headers_b

902: )
903: IS
904: SELECT mr_header_id
905: FROM
906: ahl_mr_headers_b
907: WHERE
908: upper(TITLE) = upper(mr_title)
909: and version_number = mr_version
910: and TRUNC(SYSDATE) between TRUNC(NVL(EFFECTIVE_FROM, SYSDATE)) and TRUNC(NVL(EFFECTIVE_TO, SYSDATE));