APPS.BIM_I_BGT_FACTS_PKG dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1014: ozf_funds_utilized_all_b u2

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
1018: AND u2.utilization_type in ('UTILIZED','ACCRUAL','ADJUSTMENT')

Line 1077: ozf_funds_utilized_all_b u2

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'
1081: AND ad.liability_flag='N'

Line 1145: ozf_funds_utilized_all_b u2

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'
1149: AND ad.liability_flag='N'

Line 1213: ozf_funds_utilized_all_b u2

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'
1217: AND ad.accrual_basis='SALES'

Line 1280: ozf_funds_utilized_all_b u2

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
1284: AND u2.utilization_type ='UTILIZED'

Line 1343: ozf_funds_utilized_all_b u2,

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
1347: WHERE nvl(ad.end_date_active,sysdate) >p_start_date

Line 2296: ozf_funds_utilized_all_b u2

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')
2300: GROUP BY ad.fund_id,

Line 2358: ozf_funds_utilized_all_b u2

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'
2362: AND ad.accrual_basis ='CUSTOMER'

Line 2425: ozf_funds_utilized_all_b u2

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'
2429: AND ad.accrual_basis ='SALES'

Line 2491: ozf_funds_utilized_all_b u2

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'
2495: AND ad.accrual_basis ='CUSTOMER'

Line 2558: ozf_funds_utilized_all_b u2

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'
2562: GROUP BY ad.fund_id,

Line 2620: ozf_funds_utilized_all_b u2,

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
2624: WHERE cla.claim_date between p_start_date and p_end_date