APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_FUNDS_ALL_B

Line 1145: FROM ozf_funds_all_b

1141: CURSOR l_tot_budget_csr (p_budget_id IN NUMBER) IS
1142: SELECT (NVL(original_budget, 0) + NVL(transfered_in_amt,0) - NVL(transfered_out_amt, 0))
1143: ,recal_committed
1144: ,currency_code_tc
1145: FROM ozf_funds_all_b
1146: WHERE fund_id = p_budget_id;
1147:
1148:
1149: --get forecast information.

Line 2186: from OZF_FUNDS_ALL_B where fund_id = l_prev_year_fund_id;

2182:
2183: -- getting the old budgets amount details ....
2184: CURSOR c_get_fund_details IS
2185: SELECT committed_amt,earned_amt
2186: from OZF_FUNDS_ALL_B where fund_id = l_prev_year_fund_id;
2187:
2188: -- to get the objects associated with old budget
2189: CURSOR c_get_old_fund_obj(p_fund_id IN NUMBER) IS
2190: SELECT object_type, object_id

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

2911:
2912: CURSOR c_get_fund_details(p_fund_id IN NUMBER) IS
2913: SELECT * FROM ozf_funds_all_vl
2914: WHERE fund_id = p_fund_id
2915: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b
2916: WHERE prev_fund_id = p_fund_id);
2917:
2918: -- Gets the child budgets details
2919: CURSOR c_get_child_budget(p_fund_id IN NUMBER) IS

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

2919: CURSOR c_get_child_budget(p_fund_id IN NUMBER) IS
2920: SELECT * from ozf_funds_all_vl
2921: WHERE fund_id = p_fund_id
2922: AND status_code = 'ACTIVE'
2923: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b
2924: WHERE prev_fund_id = p_fund_id);
2925:
2926: -- gets the next period budget for child's parent budget
2927: CURSOR c_get_parent_budget(p_fund_id IN NUMBER) IS

Line 2928: SELECT fund_id FROM ozf_funds_all_b

2924: WHERE prev_fund_id = p_fund_id);
2925:
2926: -- gets the next period budget for child's parent budget
2927: CURSOR c_get_parent_budget(p_fund_id IN NUMBER) IS
2928: SELECT fund_id FROM ozf_funds_all_b
2929: WHERE prev_fund_id = p_fund_id;
2930:
2931: -- This cursor gets the budgets in the hierarchy which are
2932: -- active and do not have next years budget open

Line 2935: FROM ozf_funds_all_b

2931: -- This cursor gets the budgets in the hierarchy which are
2932: -- active and do not have next years budget open
2933: CURSOR c_get_hierarchy_budgets(p_fund_id IN NUMBER) IS
2934: SELECT fund_id, parent_fund_id
2935: FROM ozf_funds_all_b
2936: WHERE prev_fund_id is NULL
2937: AND status_code = 'ACTIVE'
2938: CONNECT BY PRIOR fund_id = parent_fund_id
2939: START WITH parent_fund_id = p_fund_id;