eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_I_BGT_FACTS_PKG dependencies on OZF_FUNDS_ALL_B

Line 578: FROM ozf_funds_all_b ad

574: 0 committed_s,
575: 0 utilized_s,
576: 0 accrual_s,
577: 0 paid_s
578: FROM ozf_funds_all_b ad
579: WHERE nvl(ad.end_date_active,sysdate) >=p_start_date
580: AND ad.start_date_active <=p_end_date
581: AND ad.status_code in ('ACTIVE','CLOSED','CANCELLED')
582: AND ad.parent_fund_id is null

Line 622: FROM ozf_funds_all_b ad,

618: 0 committed_s,
619: 0 utilized_s,
620: 0 accrual_s,
621: 0 paid_s
622: FROM ozf_funds_all_b ad,
623: ozf_act_budgets BU1
624: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
625: AND bu1.approval_date <= p_end_date
626: AND bu1.transfer_type in ('TRANSFER','REQUEST')

Line 690: FROM ozf_funds_all_b ad,

686: 0 committed_s,
687: 0 utilized_s,
688: 0 accrual_s,
689: 0 paid_s
690: FROM ozf_funds_all_b ad,
691: ozf_act_budgets BU2
692: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
693: AND bu2.approval_date<=p_end_date
694: AND bu2.status_code = 'APPROVED'

Line 755: FROM ozf_funds_all_b ad,

751: 0 committed_s,
752: 0 utilized_s,
753: 0 accrual_s,
754: 0 paid_s
755: FROM ozf_funds_all_b ad,
756: ozf_act_budgets BU2
757: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
758: AND bu2.budget_source_type ='FUND'
759: AND bu2.ARC_ACT_BUDGET_USED_BY <> 'FUND'

Line 819: FROM ozf_funds_all_b ad,

815: 0 committed_s,
816: 0 utilized_s,
817: 0 accrual_s,
818: 0 paid_s
819: FROM ozf_funds_all_b ad,
820: ozf_act_budgets BU2
821: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
822: AND bu2.arc_act_budget_used_by ='FUND'
823: AND bu2.budget_source_type<>'FUND'

Line 884: FROM ozf_funds_all_b ad,

880: 0 committed_s,
881: 0 utilized_s,
882: 0 accrual_s,
883: 0 paid_s
884: FROM ozf_funds_all_b ad,
885: ozf_act_budgets BU2
886: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
887: AND bu2.budget_source_type ='FUND'
888: AND bu2.ARC_ACT_BUDGET_USED_BY <> 'FUND'

Line 948: FROM ozf_funds_all_b ad,

944: 0 committed_s,
945: 0 utilized_s,
946: 0 accrual_s,
947: 0 paid_s
948: FROM ozf_funds_all_b ad,
949: ozf_act_budgets BU2
950: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
951: AND bu2.arc_act_budget_used_by ='FUND'
952: AND bu2.budget_source_type<>'FUND'

Line 1013: FROM ozf_funds_all_b ad,

1009: 0 committed_s,
1010: 0 utilized_s,
1011: 0 accrual_s,
1012: 0 paid_s
1013: FROM ozf_funds_all_b ad,
1014: ozf_funds_utilized_all_b u2
1015: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
1016: AND ad.fund_id =u2.fund_id
1017: AND u2.creation_date <=p_end_date

Line 1076: FROM ozf_funds_all_b ad,

1072: 0 committed_s,
1073: 0 utilized_s,
1074: 0 accrual_s,
1075: 0 paid_s
1076: FROM ozf_funds_all_b ad,
1077: ozf_funds_utilized_all_b u2
1078: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
1079: AND ad.fund_id =u2.fund_id
1080: AND ad.fund_type='FULLY_ACCRUED'

Line 1144: FROM ozf_funds_all_b ad,

1140: 0 committed_s,
1141: 0 utilized_s,
1142: 0 accrual_s,
1143: 0 paid_s
1144: FROM ozf_funds_all_b ad,
1145: ozf_funds_utilized_all_b u2
1146: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
1147: AND ad.fund_id =u2.fund_id
1148: AND ad.fund_type='FULLY_ACCRUED'

Line 1212: FROM ozf_funds_all_b ad,

1208: 0 committed_s,
1209: 0 utilized_s,
1210: 0 accrual_s,
1211: 0 paid_s
1212: FROM ozf_funds_all_b ad,
1213: ozf_funds_utilized_all_b u2
1214: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
1215: AND ad.fund_id =u2.fund_id
1216: AND ad.fund_type='FULLY_ACCRUED'

Line 1279: FROM ozf_funds_all_b ad,

1275: 0 committed_s,
1276: 0 utilized_s,
1277: 0 accrual_s,
1278: 0 paid_s
1279: FROM ozf_funds_all_b ad,
1280: ozf_funds_utilized_all_b u2
1281: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
1282: AND ad.fund_id =u2.fund_id
1283: AND u2.creation_date <=p_end_date

Line 1342: FROM ozf_funds_all_b ad,

1338: 0 committed_s,
1339: 0 utilized_s,
1340: 0 accrual_s,
1341: 0 paid_s
1342: FROM ozf_funds_all_b ad,
1343: ozf_funds_utilized_all_b u2,
1344: ozf_claim_lines_util_all cuti,
1345: ozf_claim_lines_all cln,
1346: ozf_claims_all cla

Line 1859: FROM ozf_funds_all_b ad

1855: 0 committed_s,
1856: 0 utilized_s,
1857: 0 accrual_s,
1858: 0 paid_s
1859: FROM ozf_funds_all_b ad
1860: WHERE ( ( ad.status_date between p_start_date and p_end_date
1861: AND ad.start_date_active <=p_end_date
1862: )
1863: or ( ad.start_date_active between p_start_date and p_end_date

Line 1909: FROM ozf_funds_all_b ad,

1905: 0 committed_s,
1906: 0 utilized_s,
1907: 0 accrual_s,
1908: 0 paid_s
1909: FROM ozf_funds_all_b ad,
1910: ozf_act_budgets BU1
1911: WHERE bu1.approval_date between p_start_date and p_end_date
1912: AND bu1.transfer_type in ('TRANSFER','REQUEST')
1913: AND bu1.status_code = 'APPROVED'

Line 1976: FROM ozf_funds_all_b ad,

1972: 0 committed_s,
1973: 0 utilized_s,
1974: 0 accrual_s,
1975: 0 paid_s
1976: FROM ozf_funds_all_b ad,
1977: ozf_act_budgets BU2
1978: WHERE bu2.approval_date between p_start_date and p_end_date
1979: AND bu2.status_code = 'APPROVED'
1980: AND bu2.arc_act_budget_used_by = 'FUND'

Line 2040: FROM ozf_funds_all_b ad,

2036: 0 committed_s,
2037: 0 utilized_s,
2038: 0 accrual_s,
2039: 0 paid_s
2040: FROM ozf_funds_all_b ad,
2041: ozf_act_budgets BU2
2042: WHERE bu2.request_date between p_start_date and p_end_date
2043: AND bu2.budget_source_type='FUND'
2044: AND bu2.ARC_ACT_BUDGET_USED_BY <> 'FUND'

Line 2104: FROM ozf_funds_all_b ad,

2100: 0 committed_s,
2101: 0 utilized_s,
2102: 0 accrual_s,
2103: 0 paid_s
2104: FROM ozf_funds_all_b ad,
2105: ozf_act_budgets BU2
2106: WHERE bu2.approval_date between p_start_date and p_end_date
2107: AND bu2.arc_act_budget_used_by ='FUND'
2108: AND bu2.budget_source_type<>'FUND'

Line 2168: FROM ozf_funds_all_b ad,

2164: 0 committed_s,
2165: 0 utilized_s,
2166: 0 accrual_s,
2167: 0 paid_s
2168: FROM ozf_funds_all_b ad,
2169: ozf_act_budgets BU2
2170: WHERE bu2.approval_date between p_start_date and p_end_date
2171: AND bu2.budget_source_type ='FUND'
2172: AND bu2.ARC_ACT_BUDGET_USED_BY <> 'FUND'

Line 2231: FROM ozf_funds_all_b ad,

2227: 0 committed_s,
2228: 0 utilized_s,
2229: 0 accrual_s,
2230: 0 paid_s
2231: FROM ozf_funds_all_b ad,
2232: ozf_act_budgets BU2
2233: WHERE bu2.approval_date between p_start_date and p_end_date
2234: AND bu2.arc_act_budget_used_by ='FUND'
2235: AND bu2.budget_source_type<>'FUND'

Line 2295: FROM ozf_funds_all_b ad,

2291: 0 committed_s,
2292: 0 utilized_s,
2293: 0 accrual_s,
2294: 0 paid_s
2295: FROM ozf_funds_all_b ad,
2296: ozf_funds_utilized_all_b u2
2297: WHERE u2.creation_date between p_start_date and p_end_date
2298: AND ad.fund_id =u2.fund_id
2299: AND u2.utilization_type in ('UTILIZED','ACCRUAL','ADJUSTMENT')

Line 2357: FROM ozf_funds_all_b ad,

2353: 0 committed_s,
2354: 0 utilized_s,
2355: 0 accrual_s,
2356: 0 paid_s
2357: FROM ozf_funds_all_b ad,
2358: ozf_funds_utilized_all_b u2
2359: WHERE u2.creation_date between p_start_date and p_end_date
2360: AND ad.fund_id =u2.fund_id
2361: AND ad.fund_type='FULLY_ACCRUED'

Line 2424: FROM ozf_funds_all_b ad,

2420: 0 committed_s,
2421: 0 utilized_s,
2422: 0 accrual_s,
2423: 0 paid_s
2424: FROM ozf_funds_all_b ad,
2425: ozf_funds_utilized_all_b u2
2426: WHERE u2.creation_date between p_start_date and p_end_date
2427: AND ad.fund_id =u2.fund_id
2428: AND ad.fund_type='FULLY_ACCRUED'

Line 2490: FROM ozf_funds_all_b ad,

2486: 0 committed_s,
2487: 0 utilized_s,
2488: 0 accrual_s,
2489: 0 paid_s
2490: FROM ozf_funds_all_b ad,
2491: ozf_funds_utilized_all_b u2
2492: WHERE u2.creation_date between p_start_date and p_end_date
2493: AND ad.fund_id =u2.fund_id
2494: AND ad.fund_type='FULLY_ACCRUED'

Line 2557: FROM ozf_funds_all_b ad,

2553: 0 committed_s,
2554: 0 utilized_s,
2555: 0 accrual_s,
2556: 0 paid_s
2557: FROM ozf_funds_all_b ad,
2558: ozf_funds_utilized_all_b u2
2559: WHERE u2.creation_date between p_start_date and p_end_date
2560: AND ad.fund_id =u2.fund_id
2561: AND u2.utilization_type ='UTILIZED'

Line 2619: FROM ozf_funds_all_b ad,

2615: 0 committed_s,
2616: 0 utilized_s,
2617: 0 accrual_s,
2618: 0 paid_s
2619: FROM ozf_funds_all_b ad,
2620: ozf_funds_utilized_all_b u2,
2621: ozf_claim_lines_util_all cuti,
2622: ozf_claim_lines_all cln,
2623: ozf_claims_all cla