APPS.OZF_FUND_REQUEST_APR_PVT dependencies on OZF_FUNDS_ALL_VL

Line 117: FROM ozf_funds_all_vl

113: ,holdback_amt source_holdback_amt
114: ,currency_code_tc source_currency_code
115: ,object_version_number source_obj_num
116: ,committed_amt
117: FROM ozf_funds_all_vl
118: WHERE fund_id = cv_fund_id;
119:
120: l_source_rec c_fund_detail%ROWTYPE;
121: l_act_budget_obj_num NUMBER;

Line 133: FROM ozf_funds_all_vl

129: ,status_code target_status_code
130: ,user_status_id target_user_status_id
131: ,currency_code_tc target_currency_code
132: ,object_version_number target_obj_num
133: FROM ozf_funds_all_vl
134: WHERE fund_id = cv_fund_id;
135:
136: l_target_rec c_target_fund_detail%ROWTYPE;
137:

Line 150: FROM ozf_funds_all_vl

146: CURSOR c_to_fund_currency(
147: p_to_fund_id IN NUMBER)
148: IS
149: SELECT currency_code_tc
150: FROM ozf_funds_all_vl
151: WHERE fund_id = p_to_fund_id;
152:
153: l_to_currency VARCHAR2(3);
154: l_rate NUMBER;

Line 566: FROM ozf_funds_all_vl

562: ,status_code target_status_code
563: ,user_status_id target_user_status_id
564: ,currency_code_tc target_currency_code
565: ,object_version_number target_obj_num
566: FROM ozf_funds_all_vl
567: WHERE fund_id = cv_fund_id;
568:
569: l_target_rec c_target_fund_detail%ROWTYPE;
570:

Line 583: FROM ozf_funds_all_vl

579: CURSOR c_to_fund_currency(
580: p_to_fund_id IN NUMBER)
581: IS
582: SELECT currency_code_tc
583: FROM ozf_funds_all_vl
584: WHERE fund_id = p_to_fund_id;
585:
586: l_to_currency VARCHAR2(3);
587: l_rate NUMBER;

Line 929: FROM ozf_funds_all_vl

925: CURSOR c_fm_fund_currency(
926: p_fm_fund_id IN NUMBER)
927: IS
928: SELECT currency_code_tc
929: FROM ozf_funds_all_vl
930: WHERE fund_id = p_fm_fund_id;
931:
932: -- cursors to get the transfer from and transfer to currency
933: CURSOR c_to_fund_currency(

Line 937: FROM ozf_funds_all_vl

933: CURSOR c_to_fund_currency(
934: p_to_fund_id IN NUMBER)
935: IS
936: SELECT currency_code_tc
937: FROM ozf_funds_all_vl
938: WHERE fund_id = p_to_fund_id;
939:
940: -- cursor to get the act_budget_rec info ( request info)
941: CURSOR c_act_budget_rec(

Line 2257: FROM ozf_funds_all_vl

2253: ,start_date_active
2254: ,end_date_active
2255: ,owner
2256: ,currency_code_tc
2257: FROM ozf_funds_all_vl
2258: WHERE fund_id = p_act_id;
2259:
2260: CURSOR c_transfer_rec(
2261: p_act_budget_id IN NUMBER)

Line 2273: ,ozf_funds_all_vl fund

2269: ,fund.end_date_active
2270: ,act1.requester_id
2271: ,act1.request_currency
2272: FROM ozf_act_budgets act1
2273: ,ozf_funds_all_vl fund
2274: WHERE activity_budget_id = p_act_budget_id
2275: AND act1.act_budget_used_by_id = fund.fund_id;
2276:
2277: -- yzhao: 01/28/2003 get budget request's justification