APPS.OZF_BUDGETAPPROVAL_PVT dependencies on OZF_FUNDS_ALL_B

Line 93: FROM ozf_funds_all_b

89: l_org_id number := NULL;
90:
91: CURSOR get_fund_org_csr(p_id in number) IS
92: SELECT org_id
93: FROM ozf_funds_all_b
94: WHERE fund_id = (SELECT budget_source_id FROM ozf_act_budgets
95: WHERE activity_budget_id = p_id);
96:
97: BEGIN

Line 541: FROM ozf_act_budgets act, ozf_funds_all_b fund

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

Line 1680: FROM ozf_funds_all_b

1676: -- l_org_string VARCHAR2(10);
1677:
1678: CURSOR get_fund_org_csr IS
1679: SELECT org_id
1680: FROM ozf_funds_all_b
1681: WHERE fund_id = p_budget_id;
1682:
1683: BEGIN
1684: