APPS.AHL_MC_RULE_ENGINE_PVT dependencies on AHL_MC_RULE_STATEMENTS

Line 438: FROM AHL_MC_RULES_VL rul, AHL_MC_RULE_STATEMENTS rst,

434:
435: --
436: CURSOR get_rules_for_position_csr(p_rule_type IN VARCHAR2) IS
437: SELECT distinct rul.rule_id, rul.rule_name, rul.mc_header_id
438: FROM AHL_MC_RULES_VL rul, AHL_MC_RULE_STATEMENTS rst,
439: AHL_APPLICABLE_INSTANCES ap
440: WHERE rst.rule_id = rul.rule_id
441: AND rul.rule_type_code = p_rule_type
442: AND ((rst.subject_type = 'POSITION'

Line 737: FROM AHL_MC_RULE_STATEMENTS

733: IS
734: --
735: CURSOR get_rule_stmt_id_csr(p_rule_id IN NUMBER) IS
736: SELECT rule_statement_id
737: FROM AHL_MC_RULE_STATEMENTS
738: WHERE rule_id = p_rule_id
739: AND top_rule_stmt_flag = 'T';
740: --
741: l_rule_stmt_id NUMBER;

Line 825: FROM ahl_mc_rule_statements

821: IS
822: --
823: CURSOR get_rule_stmt_csr(p_rulestmt_id IN NUMBER) IS
824: SELECT *
825: FROM ahl_mc_rule_statements
826: WHERE rule_statement_id = p_rulestmt_id;
827: --
828: CURSOR get_inventory_item_csr (p_csi_ii_id IN NUMBER) IS
829: SELECT inventory_item_id