APPS.ASO_QUOTE_LINES_PVT dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 4757: from aso_price_adj_relationships a

4753: --New Code for updating PBH
4754:
4755: cursor c_pbh( p_price_adjustment_id number ) is
4756: select price_adjustment_id
4757: from aso_price_adj_relationships a
4758: where a.price_adjustment_id = ( select price_adjustment_id
4759: from aso_price_adjustments b
4760: where a.price_adjustment_id = b.price_adjustment_id
4761: and b.MODIFIER_LINE_TYPE_CODE = 'PBH')

Line 8256: FROM aso_price_adj_relationships b

8252: UPDATE aso_price_adjustments
8253: SET updated_flag = 'Y',
8254: applied_flag = null
8255: Where price_adjustment_id in ( SELECT rltd_price_adj_id
8256: FROM aso_price_adj_relationships b
8257: WHERE price_adjustment_id = l_price_adjustment_id );
8258:
8259: --update the parent PBH line
8260: UPDATE aso_price_adjustments

Line 9156: from aso_price_adjustments a, aso_price_adj_relationships b

9152: and modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
9153:
9154: cursor c_free_lines is
9155: select a.quote_line_id
9156: from aso_price_adjustments a, aso_price_adj_relationships b
9157: where a.price_adjustment_id = b.rltd_price_adj_id
9158: and b.quote_line_id = p_qte_line_rec.quote_line_id
9159: and a.quote_line_id <> p_qte_line_rec.quote_line_id;
9160:

Line 9395: from aso_price_adj_relationships rel,

9391:
9392: select rel.rltd_price_adj_id
9393: BULK COLLECT INTO
9394: adj_id_tbl
9395: from aso_price_adj_relationships rel,
9396: aso_price_adjustments adj
9397: where rel.price_adjustment_id = adj.price_adjustment_id
9398: and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
9399: and rel.price_adjustment_id in (select a.price_adjustment_id

Line 9400: from aso_price_adj_relationships a,

9396: aso_price_adjustments adj
9397: where rel.price_adjustment_id = adj.price_adjustment_id
9398: and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
9399: and rel.price_adjustment_id in (select a.price_adjustment_id
9400: from aso_price_adj_relationships a,
9401: aso_price_adjustments b
9402: where a.rltd_price_adj_id = b.price_adjustment_id
9403: and b.quote_line_id = p_qte_line_rec.quote_line_id);
9404:

Line 9441: from aso_price_adj_relationships a, aso_price_adjustments b

9437:
9438: select a.price_adjustment_id
9439: BULK COLLECT INTO
9440: adj_id_tbl
9441: from aso_price_adj_relationships a, aso_price_adjustments b
9442: where a.rltd_price_adj_id = b.price_adjustment_id
9443: and b.quote_line_id = p_qte_line_rec.quote_line_id;
9444:
9445: if aso_debug_pub.g_debug_flag = 'Y' THEN