DBA Data[Home] [Help]

APPS.AHL_WARRANTY_UTILS_PVT dependencies on CS_COUNTERS

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: