APPS.AHL_UC_POS_NECES_PVT dependencies on AHL_MC_RULES_B

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'

Line 1002: l_rule_name AHL_MC_RULES_B.RULE_NAME%TYPE;

998: l_msg_count NUMBER;
999: l_msg_data VARCHAR2(2000);
1000: l_path_position_id NUMBER;
1001: l_rule_id NUMBER;
1002: l_rule_name AHL_MC_RULES_B.RULE_NAME%TYPE;
1003: l_rule_uc_top_inst_id NUMBER;
1004: l_ret_val VARCHAR2(1) DEFAULT 'N';
1005: l_mc_header_id NUMBER;
1006: L_DEBUG_KEY VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.Quantity_Rule_Exists';