DBA Data[Home] [Help]

APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on CSI_COUNTERS_VL

Line 349: csi_counters_vl counter,

345: SELECT counter.counter_id,
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