Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as Plain Text by pet ( 13 years ago )
select ic.CREDIT_PRODUCT_FK AS iccp
from LH_INSURANCE_CONTRACT ic
join LH_INS_REMINDER_MONITOR rm on ic.INSURANCE_CONTRACT_PK = rm.INSURANCE_CONTRACT_FK
AND rm.GENERATE_REMINDER = '1'
AND rm.REMINDER_1_DATE < trunc(sysdate)
AND rm.REMINDER_SENT = 0
Revise this Paste
Parent: 66938