APPS.QP_ATTR_MAPPING_PUB dependencies on QP_EVENT_PHASES

Line 4071: FROM qp_event_phases evt, qp_adv_mod_products item

4067: -- end of 10120089
4068: IF (l_QP_CUSTOM_HOOK4_ADV_MOD='N') OR (NVL(G_PASS_THIS_LINE,'Y') = 'Y') THEN -- 10120089
4069: BEGIN
4070: SELECT 'Y' INTO l_all_items_exist
4071: FROM qp_event_phases evt, qp_adv_mod_products item
4072: WHERE INSTR(G_PRICING_EVENT, evt.pricing_event_code) > 0
4073: AND item.pricing_phase_id = evt.pricing_phase_id
4074: AND item.product_attribute = 'PRICING_ATTRIBUTE3'
4075: AND item.product_attr_value = 'ALL'

Line 4113: FROM qp_adv_mod_products item, qp_event_phases evt

4109: ||' value '||G_Product_Attr_tbl(i).attribute_value);
4110: END IF;
4111: BEGIN
4112: SELECT 'Y' INTO l_prod_exists
4113: FROM qp_adv_mod_products item, qp_event_phases evt
4114: WHERE INSTR(G_PRICING_EVENT, evt.pricing_event_code) > 0
4115: AND item.pricing_phase_id = evt.pricing_phase_id
4116: AND item.product_attribute =
4117: G_Product_Attr_tbl(i).attribute_name