APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_ORDER_GROUP_PROD

Line 981: FROM ozf_order_group_prod

977: AND tier_type = 'PBH';
978:
979: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS
980: SELECT group_no,pbh_line_id,include_volume_flag
981: FROM ozf_order_group_prod
982: WHERE order_line_id = p_order_line_id
983: AND qp_list_header_id = p_list_header_id;
984:
985: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS

Line 3806: FROM ozf_order_group_prod

3802: AND tier_type = 'PBH';
3803:
3804: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS
3805: SELECT group_no,pbh_line_id,include_volume_flag
3806: FROM ozf_order_group_prod
3807: WHERE order_line_id = p_order_line_id
3808: AND qp_list_header_id = p_list_header_id;
3809:
3810: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS

Line 3891: FROM ozf_order_group_prod

3887: --22-FEB-2007 kdass bug 5759350 - changed datatype of p_product_id from NUMBER to VARCHAR2 based on Feng's suggestion
3888: --fix for bug 5979971
3889: CURSOR c_apply_discount(p_offer_id IN NUMBER,p_line_id IN NUMBER) IS
3890: SELECT NVL(apply_discount_flag,'N')
3891: FROM ozf_order_group_prod
3892: WHERE offer_id = p_offer_id
3893: AND order_line_id = p_line_id;
3894:
3895:

Line 4638: FROM ozf_order_group_prod

4634: AND tier_type = 'PBH';
4635:
4636: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS
4637: SELECT group_no,pbh_line_id,include_volume_flag
4638: FROM ozf_order_group_prod
4639: WHERE order_line_id = p_order_line_id
4640: AND qp_list_header_id = p_list_header_id;
4641:
4642: CURSOR c_market_option(p_list_header_id IN NUMBER, p_group_id IN NUMBER) IS

Line 4710: FROM ozf_order_group_prod

4706: --22-FEB-2007 kdass bug 5759350 - changed datatype of p_product_id from NUMBER to VARCHAR2 based on Feng's suggestion
4707: --fix for bug 5979971
4708: CURSOR c_apply_discount(p_offer_id IN NUMBER,p_line_id IN NUMBER) IS
4709: SELECT NVL(apply_discount_flag,'N')
4710: FROM ozf_order_group_prod
4711: WHERE offer_id = p_offer_id
4712: AND order_line_id = p_line_id;
4713:
4714: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS