APPS.AHL_UC_POS_NECES_PVT dependencies on AHL_MC_RULE_STATEMENTS

Line 962: FROM AHL_MC_RULES_B rul, AHL_MC_RULE_STATEMENTS rst,

958: FUNCTION Quantity_Rule_Exists(p_instance_id IN NUMBER) RETURN VARCHAR2 IS
959:
960: CURSOR rule_exists_csr IS
961: SELECT distinct rul.rule_id, rul.rule_name, rul.mc_header_id
962: FROM AHL_MC_RULES_B rul, AHL_MC_RULE_STATEMENTS rst,
963: AHL_APPLICABLE_INSTANCES ap
964: WHERE rst.rule_id = rul.rule_id
965: AND rul.rule_type_code = 'MANDATORY'
966: AND rst.subject_type = 'POSITION'