APPS.OZF_FUNDRULES_PVT dependencies on OZF_FUNDS_ALL_VL

Line 68: FROM ozf_funds_all_vl

64: SELECT original_budget,
65: transfered_in_amt,
66: transfered_out_amt,
67: currency_code_tc
68: FROM ozf_funds_all_vl
69: WHERE fund_id = p_parent_id;
70:
71: CURSOR c_parent_type IS
72: SELECT fund_type

Line 73: FROM ozf_funds_all_vl

69: WHERE fund_id = p_parent_id;
70:
71: CURSOR c_parent_type IS
72: SELECT fund_type
73: FROM ozf_funds_all_vl
74: WHERE fund_id = p_parent_id;
75:
76: l_parent_fund_type VARCHAR2(30);
77: l_par_original_budget NUMBER;

Line 151: FROM ozf_funds_all_vl

147: x_return_status OUT NOCOPY VARCHAR2) IS
148: -- CURSOR for parent fund type
149: CURSOR c_parent_type IS
150: SELECT fund_type
151: FROM ozf_funds_all_vl
152: WHERE fund_id = p_parent_id;
153:
154: l_parent_fund_type VARCHAR2(30);
155: BEGIN

Line 199: FROM ozf_funds_all_vl

195: x_return_status OUT NOCOPY VARCHAR2) IS
196: -- CURSOR for parent status
197: CURSOR c_parent_status IS
198: SELECT status_code, fund_type
199: FROM ozf_funds_all_vl
200: WHERE fund_id = p_parent_id;
201:
202: l_parent_fund_status VARCHAR2(30);
203: l_parent_fund_type VARCHAR2(30);

Line 270: FROM ozf_funds_all_vl

266: -- CURSOR for parent dates
267: CURSOR c_parent_dates IS
268: SELECT start_date_active,
269: end_date_active
270: FROM ozf_funds_all_vl
271: WHERE fund_id = p_parent_id;
272:
273: l_parent_start_date DATE;
274: l_parent_end_date DATE;

Line 318: FROM ozf_funds_all_vl

314: x_return_status OUT NOCOPY VARCHAR2) IS
315: -- CURSOR for parent fund type
316: CURSOR c_parent_curr IS
317: SELECT currency_code_tc
318: FROM ozf_funds_all_vl
319: WHERE fund_id = p_parent_id;
320:
321: l_parent_fund_curr VARCHAR2(30);
322: BEGIN

Line 373: FROM ozf_funds_all_vl

369: CURSOR c_sub_fund IS
370: SELECT short_name AS short_name,
371: original_budget AS original_budget,
372: currency_code_tc AS currency_code
373: FROM ozf_funds_all_vl
374: WHERE parent_fund_id = p_fund_id;
375:
376: CURSOR c_parent_type IS
377: SELECT fund_type

Line 378: FROM ozf_funds_all_vl

374: WHERE parent_fund_id = p_fund_id;
375:
376: CURSOR c_parent_type IS
377: SELECT fund_type
378: FROM ozf_funds_all_vl
379: WHERE fund_id = p_fund_id;
380:
381: l_parent_fund_type VARCHAR2(30);
382: BEGIN

Line 455: FROM ozf_funds_all_vl

451: SELECT short_name AS short_name,
452: start_date_active AS start_date,
453: end_date_active AS end_date,
454: fund_type AS fund_type
455: FROM ozf_funds_all_vl
456: WHERE parent_fund_id = p_fund_id;
457: BEGIN
458: x_return_status := fnd_api.g_ret_sts_success;
459:

Line 520: FROM ozf_funds_all_vl

516:
517: CURSOR c_sub_fund IS
518: SELECT short_name AS short_name,
519: fund_type AS fund_type
520: FROM ozf_funds_all_vl
521: WHERE parent_fund_id = p_fund_id;
522: BEGIN
523: x_return_status := fnd_api.g_ret_sts_success;
524:

Line 564: FROM ozf_funds_all_vl

560: CURSOR c_sub_fund IS
561: SELECT short_name AS short_name,
562: currency_code_tc AS fund_curr,
563: fund_type AS fund_type
564: FROM ozf_funds_all_vl
565: WHERE parent_fund_id = p_fund_id;
566: BEGIN
567: x_return_status := fnd_api.g_ret_sts_success;
568: