APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_MARKET_PRESET_TIERS

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

1814: AND indirect_flag = DECODE(p_source_code, 'OM', 'O', 'IS', 'R');
1815:
1816: CURSOR c_preset_volume(p_offer_id NUMBER, p_group_no NUMBER, p_pbh_line_id NUMBER) IS
1817: SELECT a.volume_from
1818: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1819: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1820: AND b. pbh_offer_discount_id = p_pbh_line_id
1821: AND b.offer_market_option_id = c.offer_market_option_id
1822: AND c.offer_id = p_offer_id

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

1987: WHERE offer_discount_line_id = p_pbh_line_id;
1988:
1989: CURSOR c_preset_volume(p_offer_id NUMBER, p_group_no NUMBER, p_pbh_line_id NUMBER) IS
1990: SELECT a.volume_from
1991: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1992: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1993: AND b. pbh_offer_discount_id = p_pbh_line_id
1994: AND b.offer_market_option_id = c.offer_market_option_id
1995: AND c.offer_id = p_offer_id

Line 2538: ozf_market_preset_tiers b,

2534: BEGIN
2535:
2536: select c.volume_from ||'-' || c.volume_to into l_volume_range
2537: from ozf_offr_market_options a,
2538: ozf_market_preset_tiers b,
2539: ozf_offer_discount_lines c
2540: where a.offer_id = p_offer_id
2541: and b.offer_market_option_id = a.offer_market_option_id
2542: and a.group_number = p_group_no

Line 2564: ozf_market_preset_tiers b,

2560: BEGIN
2561:
2562: select c.discount into l_actual_discount
2563: from ozf_offr_market_options a,
2564: ozf_market_preset_tiers b,
2565: ozf_offer_discount_lines c
2566: where a.offer_id = p_offer_id
2567: and b.offer_market_option_id = a.offer_market_option_id
2568: and a.group_number = p_group_no