APPS.OZF_FUND_REQUEST_APR_PVT dependencies on OZF_ACT_BUDGETS

Line 143: FROM ozf_act_budgets

139: CURSOR c_act_budget_detail(
140: p_act_budget_id IN NUMBER)
141: IS
142: SELECT object_version_number
143: FROM ozf_act_budgets
144: WHERE activity_budget_id = p_act_budget_id;
145:
146: CURSOR c_to_fund_currency(
147: p_to_fund_id IN NUMBER)

Line 576: FROM ozf_act_budgets

572: CURSOR c_act_budget_detail(
573: p_act_budget_id IN NUMBER)
574: IS
575: SELECT object_version_number
576: FROM ozf_act_budgets
577: WHERE activity_budget_id = p_act_budget_id;
578:
579: CURSOR c_to_fund_currency(
580: p_to_fund_id IN NUMBER)

Line 947: FROM ozf_act_budgets

943: IS
944: SELECT object_version_number
945: ,request_amount
946: ,user_status_id
947: FROM ozf_act_budgets
948: WHERE activity_budget_id = p_act_budget_id;
949:
950: l_act_budget_appr_rec c_act_budget_rec%ROWTYPE;
951: BEGIN

Line 1300: FROM ozf_act_budgets act

1296: ,fund2.fund_number to_budget_number
1297: ,fund2.currency_code_tc to_budget_curr
1298: ,act.date_required_by
1299: ,act.reason_code
1300: FROM ozf_act_budgets act
1301: ,ozf_fund_details_v fund1
1302: ,ozf_fund_details_v fund2
1303: WHERE activity_budget_id = p_act_budget_id
1304: AND act.budget_source_id = fund1.fund_id

Line 1477: FROM ozf_act_budgets act

1473: ,fund2.fund_number to_budget_number
1474: ,fund2.currency_code_tc to_budget_curr
1475: ,act.date_required_by
1476: ,act.reason_code
1477: FROM ozf_act_budgets act
1478: ,ozf_fund_details_v fund1
1479: ,ozf_fund_details_v fund2
1480: WHERE activity_budget_id = p_act_budget_id
1481: AND act.budget_source_id = fund1.fund_id

Line 1679: FROM ozf_act_budgets act

1675: ,fund2.fund_number to_budget_number
1676: ,fund2.currency_code_tc to_budget_curr
1677: ,act.date_required_by
1678: ,act.reason_code
1679: FROM ozf_act_budgets act
1680: ,ozf_fund_details_v fund1
1681: ,ozf_fund_details_v fund2
1682: WHERE activity_budget_id = p_act_budget_id
1683: AND act.budget_source_id = fund1.fund_id

Line 1869: FROM ozf_act_budgets act

1865: ,fund2.fund_number to_budget_number
1866: ,fund2.currency_code_tc to_budget_curr
1867: ,act.date_required_by
1868: ,act.reason_code
1869: FROM ozf_act_budgets act
1870: ,ozf_fund_details_v fund1
1871: ,ozf_fund_details_v fund2
1872: WHERE activity_budget_id = p_act_budget_id
1873: AND act.budget_source_id = fund1.fund_id

Line 2045: FROM ozf_act_budgets act

2041: ,fund2.fund_number to_budget_number
2042: ,fund2.currency_code_tc to_budget_curr
2043: ,act.date_required_by
2044: ,act.reason_code
2045: FROM ozf_act_budgets act
2046: ,ozf_fund_details_v fund1
2047: ,ozf_fund_details_v fund2
2048: WHERE activity_budget_id = p_act_budget_id
2049: AND act.budget_source_id = fund1.fund_id

Line 2226: FROM ozf_act_budgets

2222: CURSOR c_act_budget_rec(
2223: p_act_budget_id IN NUMBER)
2224: IS
2225: SELECT act_budget_used_by_id
2226: FROM ozf_act_budgets
2227: WHERE activity_budget_id = p_act_budget_id;
2228: /* 02/26/2002 mpande added for budget transfer not picking up correct approval rules
2229: with category */
2230: CURSOR c_budget_src_rec(

Line 2234: FROM ozf_act_budgets

2230: CURSOR c_budget_src_rec(
2231: p_act_budget_id IN NUMBER)
2232: IS
2233: SELECT budget_source_id
2234: FROM ozf_act_budgets
2235: WHERE activity_budget_id = p_act_budget_id;
2236:
2237: CURSOR c_src_category(
2238: p_src_id IN NUMBER)

Line 2272: FROM ozf_act_budgets act1

2268: ,fund.start_date_active
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:

Line 2733: FROM ozf_act_budgets act

2729: SELECT budget_source_id approval_from_id
2730: ,act_budget_used_by_id approval_for_id
2731: ,request_currency
2732: ,fund.currency_code_tc
2733: FROM ozf_act_budgets act
2734: ,ozf_funds_all_b fund
2735: WHERE activity_budget_id = p_act_budget_id
2736: AND act.budget_source_id = fund.fund_id;
2737:

Line 3081: FROM ozf_act_budgets

3077: IS
3078: SELECT activity_budget_id
3079: ,status_code
3080: ,object_version_number
3081: FROM ozf_act_budgets
3082: WHERE activity_budget_id = p_act_budget_id;
3083:
3084: -- Cursor records
3085: l_request_status VARCHAR2(10);