APPS.AHL_MC_RULE_PUB dependencies on AHL_MC_HEADERS_B

Line 567: FROM AHL_MC_HEADERS_B

563: ) IS
564:
565: CURSOR chk_mc_header_id_csr (p_mc_header_id NUMBER) IS
566: SELECT 'X'
567: FROM AHL_MC_HEADERS_B
568: WHERE mc_header_id = p_mc_header_id;
569:
570: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2, p_revision VARCHAR2) IS
571: SELECT mc_header_id

Line 572: FROM AHL_MC_HEADERS_B

568: WHERE mc_header_id = p_mc_header_id;
569:
570: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2, p_revision VARCHAR2) IS
571: SELECT mc_header_id
572: FROM AHL_MC_HEADERS_B
573: WHERE name = p_mc_name
574: AND revision = p_revision;
575: --
576: l_api_version CONSTANT NUMBER := 1.0;

Line 817: FROM AHL_MC_HEADERS_B

813: ) IS
814:
815: CURSOR chk_mc_header_id_csr (p_mc_header_id NUMBER) IS
816: SELECT 'X'
817: FROM AHL_MC_HEADERS_B
818: WHERE mc_header_id = p_mc_header_id;
819:
820: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2, p_revision VARCHAR2) IS
821: SELECT mc_header_id

Line 822: FROM AHL_MC_HEADERS_B

818: WHERE mc_header_id = p_mc_header_id;
819:
820: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2, p_revision VARCHAR2) IS
821: SELECT mc_header_id
822: FROM AHL_MC_HEADERS_B
823: WHERE name = p_mc_name
824: AND revision = p_revision;
825: --
826: l_api_version CONSTANT NUMBER := 1.0;

Line 1022: FROM AHL_MC_HEADERS_B

1018: ) IS
1019:
1020: CURSOR chk_mc_header_id_csr (p_mc_header_id NUMBER) IS
1021: SELECT 'X'
1022: FROM AHL_MC_HEADERS_B
1023: WHERE mc_header_id = p_mc_header_id;
1024:
1025: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2, p_revision VARCHAR2) IS
1026: SELECT mc_header_id

Line 1027: FROM AHL_MC_HEADERS_B

1023: WHERE mc_header_id = p_mc_header_id;
1024:
1025: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2, p_revision VARCHAR2) IS
1026: SELECT mc_header_id
1027: FROM AHL_MC_HEADERS_B
1028: WHERE name = p_mc_name
1029: AND revision = p_revision;
1030: --
1031: l_api_version CONSTANT NUMBER := 1.0;

Line 1224: FROM AHL_MC_HEADERS_B

1220: ) IS
1221:
1222: CURSOR chk_mc_header_id_csr (p_mc_header_id NUMBER) IS
1223: SELECT 'X'
1224: FROM AHL_MC_HEADERS_B
1225: WHERE mc_header_id = p_mc_header_id;
1226:
1227: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2, p_revision VARCHAR2) IS
1228: SELECT mc_header_id

Line 1229: FROM AHL_MC_HEADERS_B

1225: WHERE mc_header_id = p_mc_header_id;
1226:
1227: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2, p_revision VARCHAR2) IS
1228: SELECT mc_header_id
1229: FROM AHL_MC_HEADERS_B
1230: WHERE name = p_mc_name
1231: AND revision = p_revision;
1232:
1233: CURSOR chk_rule_id_csr (p_rule_id NUMBER) IS

Line 1503: FROM AHL_MC_HEADERS_B

1499: AND MP.eam_enabled_flag = 'Y');
1500:
1501: CURSOR chk_mc_id_csr (p_mc_id NUMBER) IS
1502: SELECT 'X'
1503: FROM AHL_MC_HEADERS_B
1504: WHERE mc_id = p_mc_id;
1505:
1506: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2) IS
1507: SELECT mc_id

Line 1508: FROM AHL_MC_HEADERS_B

1504: WHERE mc_id = p_mc_id;
1505:
1506: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2) IS
1507: SELECT mc_id
1508: FROM AHL_MC_HEADERS_B
1509: WHERE name = p_mc_name;
1510:
1511: CURSOR chk_rule_stmt_id_csr (p_rule_stmt_id NUMBER) IS
1512: SELECT 'X'