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.

[Home] [Help]

APPS.BIM_I_BGT_FACTS_PKG dependencies on OZF_CLAIMS_ALL

Line 1346: ozf_claims_all cla

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
1348: AND ad.fund_id =u2.fund_id
1349: AND cla.claim_date <=p_end_date
1350: AND u2.utilization_id= cuti.utilization_id

Line 2623: ozf_claims_all cla

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
2625: AND ad.fund_id =u2.fund_id
2626: AND u2.utilization_id= cuti.utilization_id
2627: AND u2.utilization_type IN ('ACCRUAL','SALES_ACCRUAL','ADJUSTMENT')