APPS.OZF_OFFER_ADJ_PVT dependencies on QP_RLTD_MODIFIERS

Line 242: FROM qp_rltd_modifiers

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

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

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

Line 365: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c

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

Line 911: FROM ozf_offer_adjustment_lines a, qp_rltd_modifiers b

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

Line 1696: FROM qp_rltd_modifiers

1692: 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
1693: */
1694: CURSOR c_getPrgLineId(cp_listLineId NUMBER) IS
1695: SELECT from_rltd_modifier_id
1696: FROM qp_rltd_modifiers
1697: WHERE rltd_modifier_grp_type = 'BENEFIT'
1698: AND rltd_modifier_grp_no = 1
1699: AND to_rltd_modifier_id = cp_listLineId;
1700: