APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 759: FROM ozf_offers off, ozf_funds_utilized_all_b utl

755: )
756: IS
757: CURSOR c_offer_id_om(p_order_line_id NUMBER, p_object_type VARCHAR2) IS
758: SELECT off.offer_id, off.qp_list_header_id
759: FROM ozf_offers off, ozf_funds_utilized_all_b utl
760: WHERE off.qp_list_header_id = utl.plan_id
761: AND off.offer_type = 'VOLUME_OFFER'
762: AND utl.plan_type = 'OFFR'
763: AND utl.order_line_id = p_order_line_id

Line 775: FROM ozf_offers off, ozf_funds_utilized_all_b utl

771: AND utl.object_type = p_object_type;
772:
773: CURSOR c_offer_id_is(p_order_line_id NUMBER, p_object_type VARCHAR2) IS
774: SELECT off.offer_id, off.qp_list_header_id
775: FROM ozf_offers off, ozf_funds_utilized_all_b utl
776: WHERE off.qp_list_header_id = utl.plan_id
777: AND off.offer_type = 'VOLUME_OFFER'
778: AND utl.plan_type = 'OFFR'
779: AND utl.object_id = p_order_line_id

Line 1370: FROM ozf_funds_utilized_all_b

1366: )
1367: IS
1368: CURSOR c_volume_detail IS
1369: SELECT billto_cust_account_id, bill_to_site_use_id, ship_to_site_use_id
1370: FROM ozf_funds_utilized_all_b
1371: WHERE (p_source_code = 'OM' AND object_type = 'ORDER' AND order_line_id = p_order_line_id)
1372: OR (p_source_code = 'IS' AND object_type = 'TP_ORDER' AND object_id = p_order_line_id);
1373:
1374: CURSOR c_dist_acct_id IS

Line 2133: FROM ozf_funds_utilized_all_b uti

2129:
2130: select qp_list_header_id into l_qp_list_header_id from ozf_offers where offer_id = p_offer_id;
2131:
2132: SELECT SUM(uti.plan_curr_amount) into l_payout_accrual
2133: FROM ozf_funds_utilized_all_b uti
2134: WHERE uti.utilization_type IN ('UTILIZED','ACCRUAL','ADJUSTMENT','CHARGEBACK','LEAD_ACCRUAL')
2135: AND plan_type = 'OFFR'
2136: AND plan_id = l_qp_list_header_id
2137: and product_id = p_item_id