APPS.OZF_OFFER_ADJ_PVT dependencies on QP_RLTD_MODIFIERS

Line 240: FROM qp_rltd_modifiers

236: )
237: IS
238: CURSOR c_disLines(cp_pbhListLineId NUMBER) IS
239: SELECT to_rltd_modifier_id
240: FROM qp_rltd_modifiers
241: WHERE from_rltd_modifier_id = cp_pbhListLineId
242: ORDER BY to_rltd_modifier_id asc;
243: i NUMBER;
244: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;

Line 345: in qp_rltd_modifiers is used during populating the original discount structure and here also, which serves as

341:
342: /**
343: This procedure populates the discounts and start date into a PBH discount structure.
344: Since there are no keys to actually link the discounts to the structure, order by asc on to_rltd_modifier_id
345: in qp_rltd_modifiers is used during populating the original discount structure and here also, which serves as
346: the link
347: */
348: PROCEDURE processPbhStructure
349: (

Line 363: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c

359: CURSOR c_discounts(cp_offerAdjustmentId NUMBER, cp_pbhListLineId NUMBER) IS
360: SELECT
361: nvl(a.modified_discount,c.operand) discount
362: FROM
363: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c
364: WHERE
365: a.list_line_id (+) = b.to_rltd_modifier_id
366: AND b.to_rltd_modifier_id = c.list_line_id
367: AND b.from_rltd_modifier_id = cp_pbhListLineId

Line 909: FROM ozf_offer_adjustment_lines a, qp_rltd_modifiers b

905: l_phbLineId NUMBER;
906: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
907: CURSOR c_pbhLines(cp_offerAdjustmentId NUMBER) IS
908: SELECT distinct b.from_rltd_modifier_id
909: FROM ozf_offer_adjustment_lines a, qp_rltd_modifiers b
910: WHERE a.list_line_id = b.to_rltd_modifier_id
911: AND a.offer_adjustment_id = cp_offerAdjustmentId;
912: BEGIN
913: -- initialize

Line 1445: FROM qp_rltd_modifiers

1441: This cursor probably may have issues and we may have to join qp_list_lines and put a filter on list_line_type_code = PRG
1442: */
1443: CURSOR c_getPrgLineId(cp_listLineId NUMBER) IS
1444: SELECT from_rltd_modifier_id
1445: FROM qp_rltd_modifiers
1446: WHERE rltd_modifier_grp_type = 'BENEFIT'
1447: AND rltd_modifier_grp_no = 1
1448: AND to_rltd_modifier_id = cp_listLineId;
1449: