APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1058: FROM ozf_offers off, ozf_funds_utilized_all_b utl

1054: )
1055: IS
1056: CURSOR c_offer_id_om(p_order_line_id NUMBER, p_object_type VARCHAR2) IS
1057: SELECT off.offer_id, off.qp_list_header_id
1058: FROM ozf_offers off, ozf_funds_utilized_all_b utl
1059: WHERE off.qp_list_header_id = utl.plan_id
1060: AND off.offer_type = 'VOLUME_OFFER'
1061: AND utl.plan_type = 'OFFR'
1062: AND utl.order_line_id = p_order_line_id

Line 1074: FROM ozf_offers off, ozf_funds_utilized_all_b utl

1070: AND utl.object_type = p_object_type;
1071:
1072: CURSOR c_offer_id_is(p_order_line_id NUMBER, p_object_type VARCHAR2) IS
1073: SELECT off.offer_id, off.qp_list_header_id
1074: FROM ozf_offers off, ozf_funds_utilized_all_b utl
1075: WHERE off.qp_list_header_id = utl.plan_id
1076: AND off.offer_type = 'VOLUME_OFFER'
1077: AND utl.plan_type = 'OFFR'
1078: AND utl.object_id = p_order_line_id

Line 1800: FROM ozf_funds_utilized_all_b

1796: )
1797: IS
1798: CURSOR c_volume_detail IS
1799: SELECT billto_cust_account_id, bill_to_site_use_id, ship_to_site_use_id
1800: FROM ozf_funds_utilized_all_b
1801: WHERE (p_source_code = 'OM' AND object_type = 'ORDER' AND order_line_id = p_order_line_id)
1802: OR (p_source_code = 'IS' AND object_type = 'TP_ORDER' AND object_id = p_order_line_id);
1803:
1804: CURSOR c_dist_acct_id IS

Line 2594: FROM ozf_funds_utilized_all_b uti

2590: select qp_list_header_id into l_qp_list_header_id from ozf_offers where offer_id = p_offer_id;
2591:
2592: -- fixed bug 12887627
2593: SELECT SUM(uti.plan_curr_amount) into l_payout_accrual
2594: FROM ozf_funds_utilized_all_b uti
2595: WHERE uti.utilization_type IN ('UTILIZED','ACCRUAL','ADJUSTMENT','CHARGEBACK','LEAD_ACCRUAL')
2596: AND plan_type = 'OFFR'
2597: AND plan_id = l_qp_list_header_id
2598: and product_id = p_item_id