APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_MARKET_PRESET_TIERS

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

1040: ORDER BY volume_from DESC;
1041:
1042: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
1043: SELECT a.discount
1044: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1045: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1046: AND b.pbh_offer_discount_id = p_pbh_line_id
1047: AND b.offer_market_option_id = c.offer_market_option_id
1048: AND c.qp_list_header_id = p_qp_list_header_id

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

3831: AND det.source_code = p_source_code;
3832: */
3833: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
3834: SELECT a.discount
3835: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
3836: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
3837: AND b.pbh_offer_discount_id = p_pbh_line_id
3838: AND b.offer_market_option_id = c.offer_market_option_id
3839: AND c.qp_list_header_id = p_qp_list_header_id

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

4742: ORDER BY volume_from DESC;
4743:
4744: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
4745: SELECT a.discount
4746: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
4747: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
4748: AND b.pbh_offer_discount_id = p_pbh_line_id
4749: AND b.offer_market_option_id = c.offer_market_option_id
4750: AND c.qp_list_header_id = p_qp_list_header_id