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.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_VL

Line 8553: FROM ozf_funds_utilized_all_vl

8549: CURSOR csr_funds_utilized(cv_activity_product_id IN NUMBER) IS
8550: SELECT utilization_id
8551: ,amount_remaining
8552: ,scan_unit_remaining
8553: FROM ozf_funds_utilized_all_vl
8554: WHERE activity_product_id = cv_activity_product_id
8555: AND adjustment_type_id = -8
8556: AND utilization_type ='ADJUSTMENT'
8557: AND amount_remaining <> 0;

Line 8563: FROM ozf_funds_utilized_all_vl

8559: /*
8560: CURSOR csr_acc_adjustment(cv_offer_id IN NUMBER) IS
8561: SELECT utilization_id
8562: ,acctd_amount_remaining
8563: FROM ozf_funds_utilized_all_vl
8564: WHERE plan_type = 'OFFR'
8565: AND plan_id = cv_offer_id
8566: AND adjustment_type_id = -11
8567: AND utilization_type = 'ADJUSTMENT';