DBA Data[Home] [Help]

APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 350: CSI_COUNTER_ASSOCIATIONS CCA

346: tmpl_ctr.warranty_tmpl_counter_id,
347: tmpl_ctr.threshold
348: FROM ahl_warranty_tmpl_ctr_b tmpl_ctr,
349: csi_counters_vl counter,
350: CSI_COUNTER_ASSOCIATIONS CCA
351: WHERE TRUNC(NVL(counter.start_date_active, sysdate)) <= TRUNC(sysdate)
352: AND TRUNC(NVL(counter.end_date_active, sysdate+1)) > TRUNC(sysdate)
353: AND counter.COUNTER_ID = CCA.COUNTER_ID
354: AND CCA.SOURCE_OBJECT_CODE = 'CP'