APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_OFFER_DISCOUNT_LINES

Line 185: FROM ozf_offer_discount_lines

181: AND pbh_line_id = p_pbh_line_id;
182:
183: CURSOR c_pbh_lines(p_offer_id NUMBER) IS
184: SELECT offer_discount_line_id
185: FROM ozf_offer_discount_lines
186: WHERE offer_id = p_offer_id
187: AND tier_type = 'PBH';
188:
189: CURSOR c_line_processed(p_offer_id NUMBER, p_source_code VARCHAR2, p_line_id NUMBER) 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 1556: FROM ozf_offer_discount_lines

1552: AND indirect_flag = p_indirect_flag;
1553:
1554: CURSOR c_volume_type(p_pbh_line_id NUMBER) IS
1555: SELECT volume_type
1556: FROM ozf_offer_discount_lines
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

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 2027: from ozf_offer_discount_lines

2023:
2024: l_volume := get_product_volume(p_offer_id,p_pbh_line_id,p_cust_account_id,p_bill_to_id,p_ship_to_id);
2025:
2026: select volume_from ||'-' || volume_to into l_volume_range
2027: from ozf_offer_discount_lines
2028: where offer_id = p_offer_id
2029: and parent_discount_line_id = p_pbh_line_id
2030: and l_volume between volume_from and volume_to;
2031:

Line 2054: from ozf_offer_discount_lines

2050:
2051: l_volume := get_product_volume(p_offer_id,p_pbh_line_id,p_cust_account_id,p_bill_to_id,p_ship_to_id);
2052:
2053: select discount into l_actual_discount
2054: from ozf_offer_discount_lines
2055: where offer_id = p_offer_id
2056: and parent_discount_line_id = p_pbh_line_id
2057: and l_volume between volume_from and volume_to;
2058:

Line 2079: ozf_offer_discount_lines c

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
2083: and b.pbh_offer_discount_id = p_pbh_line_id

Line 2105: ozf_offer_discount_lines c

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
2109: and b.pbh_offer_discount_id = p_pbh_line_id