APPS.OZF_FUND_REQUEST_APR_PVT dependencies on OZF_FUNDS_ALL_VL

Line 115: FROM ozf_funds_all_vl

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

Line 131: FROM ozf_funds_all_vl

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

Line 148: FROM ozf_funds_all_vl

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

Line 564: FROM ozf_funds_all_vl

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

Line 581: FROM ozf_funds_all_vl

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

Line 926: FROM ozf_funds_all_vl

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

Line 934: FROM ozf_funds_all_vl

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

Line 2236: FROM ozf_funds_all_vl

2232: ,start_date_active
2233: ,end_date_active
2234: ,owner
2235: ,currency_code_tc
2236: FROM ozf_funds_all_vl
2237: WHERE fund_id = p_act_id;
2238:
2239: CURSOR c_transfer_rec(
2240: p_act_budget_id IN NUMBER)

Line 2252: ,ozf_funds_all_vl fund

2248: ,fund.end_date_active
2249: ,act1.requester_id
2250: ,act1.request_currency
2251: FROM ozf_act_budgets act1
2252: ,ozf_funds_all_vl fund
2253: WHERE activity_budget_id = p_act_budget_id
2254: AND act1.act_budget_used_by_id = fund.fund_id;
2255:
2256: -- yzhao: 01/28/2003 get budget request's justification