APPS.OZF_FUND_REQUEST_APR_PVT dependencies on OZF_ACT_BUDGETS

Line 141: FROM ozf_act_budgets

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

Line 574: FROM ozf_act_budgets

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

Line 944: FROM ozf_act_budgets

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

Line 1279: FROM ozf_act_budgets act

1275: ,fund2.fund_number to_budget_number
1276: ,fund2.currency_code_tc to_budget_curr
1277: ,act.date_required_by
1278: ,act.reason_code
1279: FROM ozf_act_budgets act
1280: ,ozf_fund_details_v fund1
1281: ,ozf_fund_details_v fund2
1282: WHERE activity_budget_id = p_act_budget_id
1283: AND act.budget_source_id = fund1.fund_id

Line 1456: FROM ozf_act_budgets act

1452: ,fund2.fund_number to_budget_number
1453: ,fund2.currency_code_tc to_budget_curr
1454: ,act.date_required_by
1455: ,act.reason_code
1456: FROM ozf_act_budgets act
1457: ,ozf_fund_details_v fund1
1458: ,ozf_fund_details_v fund2
1459: WHERE activity_budget_id = p_act_budget_id
1460: AND act.budget_source_id = fund1.fund_id

Line 1658: FROM ozf_act_budgets act

1654: ,fund2.fund_number to_budget_number
1655: ,fund2.currency_code_tc to_budget_curr
1656: ,act.date_required_by
1657: ,act.reason_code
1658: FROM ozf_act_budgets act
1659: ,ozf_fund_details_v fund1
1660: ,ozf_fund_details_v fund2
1661: WHERE activity_budget_id = p_act_budget_id
1662: AND act.budget_source_id = fund1.fund_id

Line 1848: FROM ozf_act_budgets act

1844: ,fund2.fund_number to_budget_number
1845: ,fund2.currency_code_tc to_budget_curr
1846: ,act.date_required_by
1847: ,act.reason_code
1848: FROM ozf_act_budgets act
1849: ,ozf_fund_details_v fund1
1850: ,ozf_fund_details_v fund2
1851: WHERE activity_budget_id = p_act_budget_id
1852: AND act.budget_source_id = fund1.fund_id

Line 2024: FROM ozf_act_budgets act

2020: ,fund2.fund_number to_budget_number
2021: ,fund2.currency_code_tc to_budget_curr
2022: ,act.date_required_by
2023: ,act.reason_code
2024: FROM ozf_act_budgets act
2025: ,ozf_fund_details_v fund1
2026: ,ozf_fund_details_v fund2
2027: WHERE activity_budget_id = p_act_budget_id
2028: AND act.budget_source_id = fund1.fund_id

Line 2205: FROM ozf_act_budgets

2201: CURSOR c_act_budget_rec(
2202: p_act_budget_id IN NUMBER)
2203: IS
2204: SELECT act_budget_used_by_id
2205: FROM ozf_act_budgets
2206: WHERE activity_budget_id = p_act_budget_id;
2207: /* 02/26/2002 mpande added for budget transfer not picking up correct approval rules
2208: with category */
2209: CURSOR c_budget_src_rec(

Line 2213: FROM ozf_act_budgets

2209: CURSOR c_budget_src_rec(
2210: p_act_budget_id IN NUMBER)
2211: IS
2212: SELECT budget_source_id
2213: FROM ozf_act_budgets
2214: WHERE activity_budget_id = p_act_budget_id;
2215:
2216: CURSOR c_src_category(
2217: p_src_id IN NUMBER)

Line 2251: FROM ozf_act_budgets act1

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

Line 2705: FROM ozf_act_budgets act

2701: SELECT budget_source_id approval_from_id
2702: ,act_budget_used_by_id approval_for_id
2703: ,request_currency
2704: ,fund.currency_code_tc
2705: FROM ozf_act_budgets act
2706: ,ozf_funds_all_b fund
2707: WHERE activity_budget_id = p_act_budget_id
2708: AND act.budget_source_id = fund.fund_id;
2709:

Line 3053: FROM ozf_act_budgets

3049: IS
3050: SELECT activity_budget_id
3051: ,status_code
3052: ,object_version_number
3053: FROM ozf_act_budgets
3054: WHERE activity_budget_id = p_act_budget_id;
3055:
3056: -- Cursor records
3057: l_request_status VARCHAR2(10);