APPS.OZF_OFFER_PVT dependencies on QP_RLTD_MODIFIERS

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

861:
862: CURSOR c_pbh_pricing_attr_id(l_id NUMBER) IS
863: SELECT c.pricing_attribute_id,
864: c.list_line_id
865: FROM qp_rltd_modifiers a, qp_pricing_attributes b, qp_pricing_attributes c
866: WHERE c.list_line_id = a.from_rltd_modifier_id
867: AND a.to_rltd_modifier_id = b.list_line_id
868: AND b.pricing_attribute_id = l_id;
869:

Line 5512: 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');

5508: IS
5509: CURSOR c_pricingAttr(cp_listLineId NUMBER) IS
5510: SELECT pricing_attribute_id FROM qp_pricing_attributes
5511: WHERE list_line_id = cp_listLineId
5512: 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');
5513: i NUMBER;
5514: BEGIN
5515: x_return_status := FND_API.G_RET_STS_SUCCESS;
5516: i := 1;