APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 162: FROM ozf_funds_utilized_all_b

158: AND a2.status_code = 'APPROVED'
159: AND a2.transfer_type = 'TRANSFER'
160: UNION
161: SELECT SUM(fund_request_amount) amount --nirprasa,12.2 ER 8399134 replace plan_curr_amount
162: FROM ozf_funds_utilized_all_b
163: where plan_type = p_object_type
164: and plan_id = p_object_id
165: and fund_id = p_budget_source_id);
166:

Line 179: FROM ozf_funds_utilized_all_b a1

175: /*
176: SELECT parent_source, parent_curr, SUM (amount) total_amount
177: FROM (SELECT a1.fund_id parent_source, a1.currency_code parent_curr
178: ,NVL (SUM (a1.amount), 0) amount
179: FROM ozf_funds_utilized_all_b a1
180: WHERE a1.component_id = p_budget_source_id
181: AND a1.component_type = p_budget_source_type
182: -- AND a1.status_code = 'APPROVED' -- only approved record are present here
183: AND a1.utilization_type IN ('TRANSFER', 'REQUEST')

Line 190: FROM ozf_funds_utilized_all_b a2

186: GROUP BY a1.fund_id, a1.currency_code
187: UNION
188: SELECT a2.fund_id parent_source, a2.currency_code parent_curr
189: ,-NVL (SUM (a2.amount), 0) amount
190: FROM ozf_funds_utilized_all_b a2
191: WHERE a2.plan_id = p_budget_source_id
192: AND a2.plan_type = p_budget_source_type
193: -- yzhao: 12/02/2003 11.5.10 added CHARGEBACK
194: AND a2.utilization_type IN ('TRANSFER', 'REQUEST', 'UTILIZED','ADJUSTMENT','ACCRUAL','SALES_ACCRUAL', 'CHARGEBACK')

Line 473: FROM ozf_funds_utilized_all_b a1

469: -- change by feliu on 03/26/04
470: /*
471: SELECT SUM (amount) total_amount
472: FROM (SELECT NVL (SUM (a1.amount), 0) amount
473: FROM ozf_funds_utilized_all_b a1
474: WHERE a1.component_id = p_source_id
475: AND a1.component_type = p_source_type
476: AND a1.utilization_type NOT IN
477: ('ADJUSTMENT', 'UTILIZED')

Line 481: FROM ozf_funds_utilized_all_b a2

477: ('ADJUSTMENT', 'UTILIZED')
478: GROUP BY a1.fund_id, a1.currency_code
479: UNION
480: SELECT -NVL (SUM (a2.amount), 0) amount
481: FROM ozf_funds_utilized_all_b a2
482: WHERE a2.plan_id = p_source_id
483: AND a2.plan_type = p_source_type
484: GROUP BY a2.fund_id, a2.currency_code);
485: */