[Home] [Help]
648: Fnd_Global.USER_ID,
649: SYSDATE,
650: Fnd_Global.USER_ID,
651: Fnd_Global.LOGIN_ID
652: FROM AHL_WARRANTY_TMPL_CTR_TL AWTCL,
653: FND_LANGUAGES L
654: WHERE AWTCL.WARRANTY_TMPL_COUNTER_ID (+) = warranty_contract_counter_rec.warranty_tmpl_counter_id
655: AND AWTCL.LANGUAGE (+) = L.LANGUAGE_CODE
656: AND L.INSTALLED_FLAG IN ('I', 'B')