APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_OFFR_MARKET_OPTIONS

Line 41: FROM ozf_offr_market_options

37: )
38: IS
39: CURSOR c_precedence(p_group_no NUMBER) IS
40: SELECT precedence, offer_market_option_id
41: FROM ozf_offr_market_options
42: WHERE group_number = p_group_no
43: AND qp_list_header_id = p_list_header_id;
44:
45: CURSOR c_market_options(p_offer_market_option_id NUMBER) IS

Line 47: FROM ozf_offr_market_options

43: AND qp_list_header_id = p_list_header_id;
44:
45: CURSOR c_market_options(p_offer_market_option_id NUMBER) IS
46: SELECT combine_schedule_flag, volume_tracking_level_code
47: FROM ozf_offr_market_options
48: WHERE offer_id = p_offer_id
49: AND offer_market_option_id = p_offer_market_option_id;
50: -- above cursors can be combined. offer_id is not needed as qp_list_header_id is present in table
51: CURSOR c_pbh_line_id IS

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

1384: AND indirect_flag = DECODE(p_source_code, 'OM', 'O', 'IS', 'R');
1385:
1386: CURSOR c_preset_volume(p_offer_id NUMBER, p_group_no NUMBER, p_pbh_line_id NUMBER) IS
1387: SELECT a.volume_from
1388: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1389: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1390: AND b. pbh_offer_discount_id = p_pbh_line_id
1391: AND b.offer_market_option_id = c.offer_market_option_id
1392: AND c.offer_id = p_offer_id

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

1557: WHERE offer_discount_line_id = p_pbh_line_id;
1558:
1559: CURSOR c_preset_volume(p_offer_id NUMBER, p_group_no NUMBER, p_pbh_line_id NUMBER) IS
1560: SELECT a.volume_from
1561: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1562: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1563: AND b. pbh_offer_discount_id = p_pbh_line_id
1564: AND b.offer_market_option_id = c.offer_market_option_id
1565: AND c.offer_id = p_offer_id

Line 1889: FROM ozf_offr_market_options a, ozf_offr_market_options b

1885: );
1886: /*
1887: CURSOR c_beneficiary(p_group_no NUMBER) IS
1888: SELECT a.beneficiary_party_id
1889: FROM ozf_offr_market_options a, ozf_offr_market_options b
1890: WHERE a.offer_market_option_id = b.offer_market_option_id
1891: AND b.offer_id = p_offer_id
1892: AND b.group_number = p_group_no;
1893: */

Line 1896: FROM ozf_offr_market_options

1892: AND b.group_number = p_group_no;
1893: */
1894: CURSOR c_beneficiary(p_group_no NUMBER) IS
1895: SELECT beneficiary_party_id
1896: FROM ozf_offr_market_options
1897: WHERE offer_id = p_offer_id
1898: AND group_number = p_group_no;
1899:
1900: l_group_no NUMBER;

Line 2077: from ozf_offr_market_options a,

2073: l_volume NUMBER;
2074: BEGIN
2075:
2076: select c.volume_from ||'-' || c.volume_to into l_volume_range
2077: from ozf_offr_market_options a,
2078: ozf_market_preset_tiers b,
2079: ozf_offer_discount_lines c
2080: where a.offer_id = p_offer_id
2081: and b.offer_market_option_id = a.offer_market_option_id

Line 2103: from ozf_offr_market_options a,

2099: l_volume NUMBER;
2100: BEGIN
2101:
2102: select c.discount into l_actual_discount
2103: from ozf_offr_market_options a,
2104: ozf_market_preset_tiers b,
2105: ozf_offer_discount_lines c
2106: where a.offer_id = p_offer_id
2107: and b.offer_market_option_id = a.offer_market_option_id