APPS.AHL_SB_RULES_PVT dependencies on AHL_MR_HEADERS_B

Line 820: FROM AHL_MR_HEADERS_B

816:
817: -- cursor to check the MR header id
818: CURSOR chk_mr_header_id_csr (c_mr_header_id NUMBER) IS
819: SELECT 'X'
820: FROM AHL_MR_HEADERS_B
821: WHERE mr_header_id = c_mr_header_id
822: AND program_type_code = 'SERV_BLTN'
823: AND mr_status_code <> 'TERMINATED';
824:

Line 1031: FROM AHL_MR_HEADERS_B

1027: -- Modified by SURRKUMA :: 12896263 :: 16-FEB-2012
1028: -- cursor to check the given MR header id
1029: CURSOR chk_mr_header_id_csr (c_mr_header_id NUMBER) IS
1030: SELECT 'X'
1031: FROM AHL_MR_HEADERS_B
1032: WHERE mr_header_id = c_mr_header_id
1033: AND program_type_code = 'SERV_BLTN';
1034:
1035: -- cursor to get the MC header id for a unit

Line 1257: FROM AHL_MR_HEADERS_B

1253:
1254: -- cursor to check the given MR header id
1255: CURSOR chk_mr_header_id_csr (c_mr_header_id NUMBER) IS
1256: SELECT 'X'
1257: FROM AHL_MR_HEADERS_B
1258: WHERE mr_header_id = c_mr_header_id
1259: AND program_type_code = 'SERV_BLTN'
1260: AND mr_status_code = 'DRAFT';
1261:

Line 1898: FROM AHL_MR_HEADERS_B

1894:
1895: -- cursor to check the given MR header id
1896: CURSOR chk_mr_header_id_csr (c_mr_header_id NUMBER) IS
1897: SELECT 'X'
1898: FROM AHL_MR_HEADERS_B
1899: WHERE mr_header_id = c_mr_header_id
1900: AND program_type_code = 'SERV_BLTN';
1901:
1902: -- cursor to get the MC header id for a unit