DBA Data[Home] [Help]

APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on AHL_WARRANTY_TMPL_CTR_B

Line 348: FROM ahl_warranty_tmpl_ctr_b tmpl_ctr,

344: CURSOR warranty_contract_counter_csr (c_warranty_template_id NUMBER, c_item_instance_id NUMBER) IS
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)