APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_MARKET_PRESET_TIERS

Line 1205: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

1201: ORDER BY volume_from DESC;
1202:
1203: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
1204: SELECT a.discount
1205: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1206: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1207: AND b.pbh_offer_discount_id = p_pbh_line_id
1208: AND b.offer_market_option_id = c.offer_market_option_id
1209: AND c.qp_list_header_id = p_qp_list_header_id

Line 7891: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

7887: AND det.source_code = p_source_code;
7888: */
7889: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
7890: SELECT a.discount
7891: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
7892: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
7893: AND b.pbh_offer_discount_id = p_pbh_line_id
7894: AND b.offer_market_option_id = c.offer_market_option_id
7895: AND c.qp_list_header_id = p_qp_list_header_id

Line 9036: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

9032: ORDER BY volume_from DESC;
9033:
9034: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
9035: SELECT a.discount
9036: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
9037: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
9038: AND b.pbh_offer_discount_id = p_pbh_line_id
9039: AND b.offer_market_option_id = c.offer_market_option_id
9040: AND c.qp_list_header_id = p_qp_list_header_id