APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_OFFR_MARKET_OPTIONS

Line 48: FROM ozf_offr_market_options

44: )
45: IS
46: CURSOR c_precedence(p_group_no NUMBER) IS
47: SELECT precedence, offer_market_option_id
48: FROM ozf_offr_market_options
49: WHERE group_number = p_group_no
50: AND qp_list_header_id = p_list_header_id;
51:
52: CURSOR c_market_options(p_offer_market_option_id NUMBER) IS

Line 54: FROM ozf_offr_market_options

50: AND qp_list_header_id = p_list_header_id;
51:
52: CURSOR c_market_options(p_offer_market_option_id NUMBER) IS
53: SELECT combine_schedule_flag, volume_tracking_level_code
54: FROM ozf_offr_market_options
55: WHERE offer_id = p_offer_id
56: AND offer_market_option_id = p_offer_market_option_id;
57: -- above cursors can be combined. offer_id is not needed as qp_list_header_id is present in table
58: CURSOR c_pbh_line_id IS

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 2342: FROM ozf_offr_market_options a, ozf_offr_market_options b

2338:
2339: /*
2340: CURSOR c_beneficiary(p_group_no NUMBER) IS
2341: SELECT a.beneficiary_party_id
2342: FROM ozf_offr_market_options a, ozf_offr_market_options b
2343: WHERE a.offer_market_option_id = b.offer_market_option_id
2344: AND b.offer_id = p_offer_id
2345: AND b.group_number = p_group_no;
2346: */

Line 2349: FROM ozf_offr_market_options

2345: AND b.group_number = p_group_no;
2346: */
2347: CURSOR c_beneficiary(p_group_no NUMBER) IS
2348: SELECT beneficiary_party_id
2349: FROM ozf_offr_market_options
2350: WHERE offer_id = p_offer_id
2351: AND group_number = p_group_no;
2352:
2353: l_group_no NUMBER;

Line 2537: from ozf_offr_market_options a,

2533: l_volume NUMBER;
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

Line 2563: from ozf_offr_market_options a,

2559: l_volume NUMBER;
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