APPS.AHL_MC_RULE_ENGINE_PVT dependencies on AHL_MC_RULES_B

Line 46: FROM AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc

42: IS
43: --
44: CURSOR get_rules_for_unit_csr(p_uc_header_id IN NUMBER, p_rtype IN VARCHAR2) IS
45: SELECT DISTINCT rules.rule_id, uc.csi_item_instance_id
46: FROM AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc
47: WHERE rules.mc_header_id = uc.master_config_id
48: AND uc.unit_config_header_id = p_uc_header_id
49: AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
50: AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 215: FROM AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc

211: IS
212: --
213: CURSOR get_rules_for_unit_csr(p_uc_header_id IN NUMBER, p_rtype IN VARCHAR2) IS
214: SELECT DISTINCT rules.rule_id, rules.rule_name, uc.csi_item_instance_id, uc.name
215: FROM AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc
216: WHERE rules.mc_header_id = uc.master_config_id
217: AND uc.unit_config_header_id = p_uc_header_id
218: AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
219: AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 238: l_rule_name AHL_MC_RULES_B.RULE_NAME%TYPE;

234: l_api_version CONSTANT NUMBER := 1.0;
235: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rules_For_Unit';
236: l_csi_ii_id NUMBER;
237: l_rule_id NUMBER;
238: l_rule_name AHL_MC_RULES_B.RULE_NAME%TYPE;
239: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%TYPE;
240: l_eval_result VARCHAR2(1);
241: l_all_true_flag BOOLEAN;
242: l_uc_header_id NUMBER;

Line 499: l_rule_name AHL_MC_RULES_B.RULE_NAME%TYPE;

495: --
496: l_api_version CONSTANT NUMBER := 1.0;
497: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rules_For_Position';
498: l_rule_id NUMBER;
499: l_rule_name AHL_MC_RULES_B.RULE_NAME%TYPE;
500: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%TYPE;
501: l_mc_header_id NUMBER;
502: l_csi_ii_id NUMBER;
503: l_eval_result VARCHAR2(1);