APPS.AHL_MC_RULE_ENGINE_PVT dependencies on AHL_APPLICABLE_INSTANCES

Line 439: AHL_APPLICABLE_INSTANCES ap

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'
443: AND rst.subject_id = ap.position_id )

Line 558: EXECUTE IMMEDIATE 'DELETE FROM AHL_APPLICABLE_INSTANCES';

554: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
555: ' l_item_instance_id => '||l_item_instance_id||', l_parent_instance_id => '||l_parent_instance_id);
556: END IF;
557:
558: EXECUTE IMMEDIATE 'DELETE FROM AHL_APPLICABLE_INSTANCES';
559:
560: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
561: -- Modify the reference of p_item_instance_id to l_item_instance_id.
562: AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Positions