APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on AHL_MR_HEADERS_B

Line 867: ahl_mr_headers_b

863: )
864: IS
865: SELECT 'x'
866: FROM
867: ahl_mr_headers_b
868: WHERE
869: mr_header_id = mr_header_id
870: and upper(program_type_code) = upper('MO_PROC');
871: --and upper(mr_status_code) = upper('COMPLETE')

Line 883: ahl_mr_headers_b

879: )
880: IS
881: SELECT mr_status_code
882: FROM
883: ahl_mr_headers_b
884: WHERE
885: mr_header_id = mr_header_id
886: --and upper(program_type_code) = upper('MO_PROC')
887: and upper(mr_status_code) = upper('COMPLETE')

Line 900: ahl_mr_headers_b

896: )
897: IS
898: SELECT mr_header_id
899: FROM
900: ahl_mr_headers_b
901: WHERE
902: upper(TITLE) = upper(mr_title)
903: and version_number = mr_version
904: and TRUNC(SYSDATE) between TRUNC(NVL(EFFECTIVE_FROM, SYSDATE)) and TRUNC(NVL(EFFECTIVE_TO, SYSDATE));