APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_FUNDS_ALL_B

Line 130: FROM ozf_funds_all_b

126: /*
127: -- Cursor to get the org_id for budget
128: CURSOR c_fund_org_id (p_fund_id IN NUMBER)IS
129: SELECT org_id, ledger_id
130: FROM ozf_funds_all_b
131: WHERE fund_id = p_fund_id;
132: */
133:
134: -- l_activity_product_id NUMBER;

Line 165: FROM ozf_funds_all_b

161: ,paid_amt
162: ,plan_id
163: ,liability_flag -- yzhao: 10/20/2003 added
164: ,recal_committed -- yzhao: 10/20/2003 added
165: FROM ozf_funds_all_b
166: WHERE fund_id = p_fund_id;
167:
168: --- Cursor to get the adjustment_type from adjustmentId
169: CURSOR c_adj_type (p_adj_type_id IN NUMBER) IS

Line 241: ,ozf_funds_all_b fun

237: -- yzhao: 11.5.10 check if post to gl for off invoice discount
238: CURSOR c_offinvoice_gl_post_flag(p_fund_id IN NUMBER) IS
239: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
240: FROM ozf_sys_parameters_all sob
241: ,ozf_funds_all_b fun
242: WHERE fun.fund_id = p_fund_id
243: AND sob.org_id = fun.ORG_id ;
244: */
245: CURSOR c_offinvoice_gl_post_flag(p_org_id IN NUMBER) IS

Line 2128: FROM ozf_funds_all_b

2124:
2125: CURSOR c_fund_b (p_fund_id IN NUMBER) IS
2126: SELECT utilized_amt
2127: ,object_version_number
2128: FROM ozf_funds_all_b
2129: WHERE fund_id = p_fund_id;
2130:
2131: CURSOR c_old_util_amt (p_util_id IN NUMBER) IS
2132: SELECT amount

Line 2741: 'ozf_funds_all_b'

2737:
2738: ----------------------- fund_id ------------------------
2739: IF p_utilization_rec.fund_id <> fnd_api.g_miss_num THEN
2740: IF ozf_utility_pvt.check_fk_exists (
2741: 'ozf_funds_all_b'
2742: , -- Parent schema object having the primary key
2743: 'fund_id'
2744: , -- Column name in the parent object that maps to the fk value
2745: p_utilization_rec.fund_id -- Value of fk to be validated against the parent object's pk column

Line 3144: FROM ozf_funds_all_b

3140: l_status VARCHAR2 (30);
3141:
3142: CURSOR c_budget_rec (p_fund_id IN NUMBER) IS
3143: SELECT status_code
3144: FROM ozf_funds_all_b
3145: WHERE fund_id = p_fund_id;
3146: BEGIN
3147: OPEN c_budget_rec (p_fund_id);
3148: FETCH c_budget_rec INTO l_status;

Line 3185: FROM ozf_funds_all_b ozf

3181: ,x_return_status OUT NOCOPY VARCHAR2
3182: ) IS
3183: CURSOR c_fund_type (p_fund_id IN NUMBER) IS
3184: SELECT 'X'
3185: FROM ozf_funds_all_b ozf
3186: WHERE ozf.fund_type = 'FULLY_ACCRUED'
3187: AND ozf.fund_id = p_fund_id;
3188:
3189: l_dummy VARCHAR2 (3) := 'X';