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
1305: AND act.act_budget_used_by_id = fund2.fund_id;
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
1305: AND act.act_budget_used_by_id = fund2.fund_id;
1306:
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
1482: AND act.act_budget_used_by_id = fund2.fund_id;
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
1482: AND act.act_budget_used_by_id = fund2.fund_id;
1483:
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
1684: AND act.act_budget_used_by_id = fund2.fund_id;
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
1684: AND act.act_budget_used_by_id = fund2.fund_id;
1685:
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
1874: AND act.act_budget_used_by_id = fund2.fund_id;
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
1874: AND act.act_budget_used_by_id = fund2.fund_id;
1875:
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
2050: AND act.act_budget_used_by_id = fund2.fund_id;
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
2050: AND act.act_budget_used_by_id = fund2.fund_id;
2051: