DBA Data[Home] [Help]

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on OZF_FUNDS_ALL_B

Line 97: FROM ozf_funds_all_b

93: l_org_id number := NULL;
94:
95: CURSOR get_fund_org_csr(p_id in number) IS
96: SELECT org_id
97: FROM ozf_funds_all_b
98: WHERE fund_id = (SELECT budget_source_id FROM ozf_act_budgets
99: WHERE activity_budget_id = p_id);
100:
101: BEGIN

Line 545: FROM ozf_act_budgets act, ozf_funds_all_b fund

541: CURSOR c_get_actbudgets IS
542: SELECT act.activity_budget_id, act.budget_source_id,
543: (fund.committed_amt - act.request_amount) committed_amt,
544: fund.object_version_number
545: FROM ozf_act_budgets act, ozf_funds_all_b fund
546: WHERE act.arc_act_budget_used_by = 'OFFR'
547: AND act.act_budget_used_by_id = p_offer_id
548: AND act.transfer_type = 'REQUEST'
549: AND act.status_code = 'APPROVED'

Line 1684: FROM ozf_funds_all_b

1680: -- l_org_string VARCHAR2(10);
1681:
1682: CURSOR get_fund_org_csr IS
1683: SELECT org_id
1684: FROM ozf_funds_all_b
1685: WHERE fund_id = p_budget_id;
1686:
1687: BEGIN
1688: