APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_FUNDS_ALL_B

Line 1132: FROM ozf_funds_all_b

1128: CURSOR l_tot_budget_csr (p_budget_id IN NUMBER) IS
1129: SELECT (NVL(original_budget, 0) + NVL(transfered_in_amt,0) - NVL(transfered_out_amt, 0))
1130: ,recal_committed
1131: ,currency_code_tc
1132: FROM ozf_funds_all_b
1133: WHERE fund_id = p_budget_id;
1134:
1135:
1136: --get forecast information.

Line 2138: from OZF_FUNDS_ALL_B where fund_id = l_prev_year_fund_id;

2134:
2135: -- getting the old budgets amount details ....
2136: CURSOR c_get_fund_details IS
2137: SELECT committed_amt,earned_amt
2138: from OZF_FUNDS_ALL_B where fund_id = l_prev_year_fund_id;
2139:
2140: -- to get the objects associated with old budget
2141: CURSOR c_get_old_fund_obj(p_fund_id IN NUMBER) IS
2142: SELECT object_type, object_id

Line 2867: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b

2863:
2864: CURSOR c_get_fund_details(p_fund_id IN NUMBER) IS
2865: SELECT * FROM ozf_funds_all_vl
2866: WHERE fund_id = p_fund_id
2867: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b
2868: WHERE prev_fund_id = p_fund_id);
2869:
2870: -- Gets the child budgets details
2871: CURSOR c_get_child_budget(p_fund_id IN NUMBER) IS

Line 2875: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b

2871: CURSOR c_get_child_budget(p_fund_id IN NUMBER) IS
2872: SELECT * from ozf_funds_all_vl
2873: WHERE fund_id = p_fund_id
2874: AND status_code = 'ACTIVE'
2875: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b
2876: WHERE prev_fund_id = p_fund_id);
2877:
2878: -- gets the next period budget for child's parent budget
2879: CURSOR c_get_parent_budget(p_fund_id IN NUMBER) IS

Line 2880: SELECT fund_id FROM ozf_funds_all_b

2876: WHERE prev_fund_id = p_fund_id);
2877:
2878: -- gets the next period budget for child's parent budget
2879: CURSOR c_get_parent_budget(p_fund_id IN NUMBER) IS
2880: SELECT fund_id FROM ozf_funds_all_b
2881: WHERE prev_fund_id = p_fund_id;
2882:
2883: -- This cursor gets the budgets in the hierarchy which are
2884: -- active and do not have next years budget open

Line 2887: FROM ozf_funds_all_b

2883: -- This cursor gets the budgets in the hierarchy which are
2884: -- active and do not have next years budget open
2885: CURSOR c_get_hierarchy_budgets(p_fund_id IN NUMBER) IS
2886: SELECT fund_id, parent_fund_id
2887: FROM ozf_funds_all_b
2888: WHERE prev_fund_id is NULL
2889: AND status_code = 'ACTIVE'
2890: CONNECT BY PRIOR fund_id = parent_fund_id
2891: START WITH parent_fund_id = p_fund_id;