[Home] [Help]
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
1284: AND act.act_budget_used_by_id = fund2.fund_id;
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
1284: AND act.act_budget_used_by_id = fund2.fund_id;
1285:
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
1461: AND act.act_budget_used_by_id = fund2.fund_id;
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
1461: AND act.act_budget_used_by_id = fund2.fund_id;
1462:
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
1663: AND act.act_budget_used_by_id = fund2.fund_id;
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
1663: AND act.act_budget_used_by_id = fund2.fund_id;
1664:
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
1853: AND act.act_budget_used_by_id = fund2.fund_id;
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
1853: AND act.act_budget_used_by_id = fund2.fund_id;
1854:
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
2029: AND act.act_budget_used_by_id = fund2.fund_id;
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
2029: AND act.act_budget_used_by_id = fund2.fund_id;
2030: