APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_MARKET_PRESET_TIERS

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 2078: ozf_market_preset_tiers b,

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
2082: and a.group_number = p_group_no

Line 2104: ozf_market_preset_tiers b,

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
2108: and a.group_number = p_group_no