APPS.QP_ATTR_MAPPING_PUB dependencies on QP_ADV_MOD_PRODUCTS

Line 3799: FROM qp_event_phases evt, qp_adv_mod_products item

3795: l_all_items_exist VARCHAR2(1) := 'N';
3796: BEGIN
3797: BEGIN
3798: SELECT 'Y' INTO l_all_items_exist
3799: FROM qp_event_phases evt, qp_adv_mod_products item
3800: WHERE INSTR(G_PRICING_EVENT, evt.pricing_event_code) > 0
3801: AND item.pricing_phase_id = evt.pricing_phase_id
3802: AND item.product_attribute = 'PRICING_ATTRIBUTE3'
3803: AND item.product_attr_value = 'ALL'

Line 3841: FROM qp_adv_mod_products item, qp_event_phases evt

3837: ||' value '||G_Product_Attr_tbl(i).attribute_value);
3838: END IF;
3839: BEGIN
3840: SELECT 'Y' INTO l_prod_exists
3841: FROM qp_adv_mod_products item, qp_event_phases evt
3842: WHERE INSTR(G_PRICING_EVENT, evt.pricing_event_code) > 0
3843: AND item.pricing_phase_id = evt.pricing_phase_id
3844: AND item.product_attribute =
3845: G_Product_Attr_tbl(i).attribute_name