DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_VL

Line 10944: FROM ozf_funds_utilized_all_vl

10940: CURSOR csr_funds_utilized(cv_activity_product_id IN NUMBER) IS
10941: SELECT utilization_id
10942: ,amount_remaining
10943: ,scan_unit_remaining
10944: FROM ozf_funds_utilized_all_vl
10945: WHERE activity_product_id = cv_activity_product_id
10946: AND adjustment_type_id = -8
10947: AND utilization_type ='ADJUSTMENT'
10948: AND amount_remaining <> 0;

Line 10954: FROM ozf_funds_utilized_all_vl

10950: /*
10951: CURSOR csr_acc_adjustment(cv_offer_id IN NUMBER) IS
10952: SELECT utilization_id
10953: ,acctd_amount_remaining
10954: FROM ozf_funds_utilized_all_vl
10955: WHERE plan_type = 'OFFR'
10956: AND plan_id = cv_offer_id
10957: AND adjustment_type_id = -11
10958: AND utilization_type = 'ADJUSTMENT';