APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 159: FROM ozf_funds_utilized_all_b

155: AND a2.status_code = 'APPROVED'
156: AND a2.transfer_type = 'TRANSFER'
157: UNION
158: SELECT SUM(amount) amount
159: FROM ozf_funds_utilized_all_b
160: where plan_type = p_object_type
161: and plan_id = p_object_id
162: and fund_id = p_budget_source_id);
163:

Line 176: FROM ozf_funds_utilized_all_b a1

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

Line 187: FROM ozf_funds_utilized_all_b a2

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

Line 467: FROM ozf_funds_utilized_all_b a1

463: -- change by feliu on 03/26/04
464: /*
465: SELECT SUM (amount) total_amount
466: FROM (SELECT NVL (SUM (a1.amount), 0) amount
467: FROM ozf_funds_utilized_all_b a1
468: WHERE a1.component_id = p_source_id
469: AND a1.component_type = p_source_type
470: AND a1.utilization_type NOT IN
471: ('ADJUSTMENT', 'UTILIZED')

Line 475: FROM ozf_funds_utilized_all_b a2

471: ('ADJUSTMENT', 'UTILIZED')
472: GROUP BY a1.fund_id, a1.currency_code
473: UNION
474: SELECT -NVL (SUM (a2.amount), 0) amount
475: FROM ozf_funds_utilized_all_b a2
476: WHERE a2.plan_id = p_source_id
477: AND a2.plan_type = p_source_type
478: GROUP BY a2.fund_id, a2.currency_code);
479: */