APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_ACT_BUDGETS

Line 639: FROM ozf_act_budgets a1

635: CURSOR c_parent_source_obj IS
636: SELECT SUM (amount) total_amount
637: FROM (SELECT --- request amount
638: NVL (SUM (a1.approved_amount), 0) amount
639: FROM ozf_act_budgets a1
640: WHERE a1.act_budget_used_by_id = p_budget_used_by_id
641: AND a1.arc_act_budget_used_by = p_budget_used_by_type
642: AND a1.status_code = 'APPROVED'
643: AND a1.transfer_type ='REQUEST'

Line 647: FROM ozf_act_budgets a2

643: AND a1.transfer_type ='REQUEST'
644: AND parent_act_budget_id is null
645: UNION -- transfer and utilized amount
646: SELECT -NVL (SUM (a2.approved_original_amount), 0) amount
647: FROM ozf_act_budgets a2
648: WHERE a2.budget_source_id = p_budget_used_by_id
649: AND a2.budget_source_type = p_budget_used_by_type
650: AND a2.status_code = 'APPROVED'
651: AND a2.transfer_type <>'REQUEST'

Line 701: FROM ozf_act_budgets a1

697:
698: --nirprasa for bug 7425189, use request approval date to get exchnage rate
699: CURSOR c_exchange_rate_date(p_fund_id IN NUMBER) IS
700: SELECT approval_date
701: FROM ozf_act_budgets a1
702: WHERE a1.act_budget_used_by_id = p_budget_used_by_id
703: AND a1.arc_act_budget_used_by = p_budget_used_by_type
704: AND a1.status_code = 'APPROVED'
705: AND a1.transfer_type = 'REQUEST'