APPS.AHL_WARRANTY_UTILS_PVT dependencies on AHL_WARRANTY_CONT_CTR_B

Line 111: FROM ahl_warranty_cont_ctr_b cntrt, cs_counters ctr

107: --fetch counters associated with the contract
108: CURSOR get_counter_details (c_warranty_contract_id IN NUMBER)
109: IS
110: SELECT cntrt.warranty_cntrt_counter_id,cntrt.counter_id,cntrt.object_version_number,ctr.uom_code,cntrt.threshold,cntrt.start_value
111: FROM ahl_warranty_cont_ctr_b cntrt, cs_counters ctr
112: WHERE cntrt.warranty_contract_id = c_warranty_contract_id
113: AND cntrt.counter_id = ctr.counter_id
114: FOR UPDATE of expiration_date ;
115:

Line 219: UPDATE AHL_WARRANTY_CONT_CTR_B SET EXPIRATION_DATE = l_warranty_counter_tbl(i).counter_expiration_date,

215: END IF;
216:
217: --Update Contract Counter table with new expiration date
218: FORALL i IN l_warranty_counter_tbl.FIRST..l_warranty_counter_tbl.LAST
219: UPDATE AHL_WARRANTY_CONT_CTR_B SET EXPIRATION_DATE = l_warranty_counter_tbl(i).counter_expiration_date,
220: OBJECT_VERSION_NUMBER = l_warranty_counter_tbl(i).object_version_number+1,
221: LAST_UPDATE_DATE = sysdate,
222: LAST_UPDATED_BY = l_user_id,
223: LAST_UPDATE_LOGIN = l_login_id,