APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_OFFER_DISCOUNT_LINES

Line 216: FROM ozf_offer_discount_lines

212: AND pbh_line_id = p_pbh_line_id;
213:
214: CURSOR c_pbh_lines(p_offer_id NUMBER) IS
215: SELECT offer_discount_line_id
216: FROM ozf_offer_discount_lines
217: WHERE offer_id = p_offer_id
218: AND tier_type = 'PBH';
219:
220: CURSOR c_line_processed(p_offer_id NUMBER, p_source_code VARCHAR2, p_line_id NUMBER) IS

Line 1093: FROM ozf_offer_discount_lines

1089:
1090: -- Catch Weight ER - start
1091: CURSOR c_offer_uom_code(l_offer_id NUMBER) IS
1092: SELECT uom_code
1093: FROM ozf_offer_discount_lines
1094: WHERE offer_id = l_offer_id;
1095: l_offer_uom_code VARCHAR2(10);
1096: l_uom_ratio NUMBER := 1;
1097: l_volume_detail_rec ozf_sales_transactions_pvt.sales_transaction_rec_type;

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 1986: FROM ozf_offer_discount_lines

1982: AND indirect_flag = p_indirect_flag;
1983:
1984: CURSOR c_volume_type(p_pbh_line_id NUMBER) IS
1985: SELECT volume_type
1986: FROM ozf_offer_discount_lines
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

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

2481: --kdass bug 13256460 - added p_group_no
2482: l_volume := get_product_volume(p_offer_id,p_pbh_line_id,p_cust_account_id,p_bill_to_id,p_ship_to_id,p_group_no);
2483:
2484: select volume_from ||'-' || volume_to into l_volume_range
2485: from ozf_offer_discount_lines
2486: where offer_id = p_offer_id
2487: and parent_discount_line_id = p_pbh_line_id
2488: and l_volume >= volume_from and l_volume < volume_to; --kdass bug 13256460
2489:

Line 2514: from ozf_offer_discount_lines

2510: --kdass bug 13256460 - added p_group_no
2511: l_volume := get_product_volume(p_offer_id,p_pbh_line_id,p_cust_account_id,p_bill_to_id,p_ship_to_id,p_group_no);
2512:
2513: select discount into l_actual_discount
2514: from ozf_offer_discount_lines
2515: where offer_id = p_offer_id
2516: and parent_discount_line_id = p_pbh_line_id
2517: and l_volume >= volume_from and l_volume < volume_to; --kdass bug 13256460
2518:

Line 2539: ozf_offer_discount_lines c

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

Line 2565: ozf_offer_discount_lines c

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