APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_ACT_BUDGETS

Line 642: FROM ozf_act_budgets a1

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

Line 650: FROM ozf_act_budgets a2

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

Line 704: FROM ozf_act_budgets a1

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