APPS.AHL_MC_RULE_PUB dependencies on AHL_MC_RULES_B

Line 1235: FROM AHL_MC_RULES_B

1231: AND revision = p_revision;
1232:
1233: CURSOR chk_rule_id_csr (p_rule_id NUMBER) IS
1234: SELECT 'X'
1235: FROM AHL_MC_RULES_B
1236: WHERE rule_id = p_rule_id;
1237:
1238: CURSOR chk_rule_name_csr (p_rule_name VARCHAR2, p_mc_header_id NUMBER) IS
1239: SELECT rule_id

Line 1240: FROM AHL_MC_RULES_B

1236: WHERE rule_id = p_rule_id;
1237:
1238: CURSOR chk_rule_name_csr (p_rule_name VARCHAR2, p_mc_header_id NUMBER) IS
1239: SELECT rule_id
1240: FROM AHL_MC_RULES_B
1241: WHERE rule_name = p_rule_name
1242: AND mc_header_id = p_mc_header_id;
1243:
1244: CURSOR chk_lookup_code_csr (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS