APPS.OZF_OFFER_PVT dependencies on QP_RLTD_MODIFIERS

Line 771: FROM qp_rltd_modifiers a, qp_pricing_attributes b, qp_pricing_attributes c

767:
768: CURSOR c_pbh_pricing_attr_id(l_id NUMBER) IS
769: SELECT c.pricing_attribute_id,
770: c.list_line_id
771: FROM qp_rltd_modifiers a, qp_pricing_attributes b, qp_pricing_attributes c
772: WHERE c.list_line_id = a.from_rltd_modifier_id
773: AND a.to_rltd_modifier_id = b.list_line_id
774: AND b.pricing_attribute_id = l_id;
775:

Line 5134: OR list_line_id IN (select to_rltd_modifier_id FROM qp_rltd_modifiers WHERE from_rltd_modifier_id = cp_listLineId AND rltd_modifier_grp_type = 'PRICE BREAK');

5130: IS
5131: CURSOR c_pricingAttr(cp_listLineId NUMBER) IS
5132: SELECT pricing_attribute_id FROM qp_pricing_attributes
5133: WHERE list_line_id = cp_listLineId
5134: OR list_line_id IN (select to_rltd_modifier_id FROM qp_rltd_modifiers WHERE from_rltd_modifier_id = cp_listLineId AND rltd_modifier_grp_type = 'PRICE BREAK');
5135: i NUMBER;
5136: BEGIN
5137: x_return_status := FND_API.G_RET_STS_SUCCESS;
5138: i := 1;