[Home] [Help]
719: LAST_UPDATE_LOGIN
720: )
721: VALUES
722: (
723: IGS_AD_CONTACTS_INT_S.NEXTVAL,
724: l_interface_id,
725: 'PHONE', -- COMMUNICATION_TYPE
726: 'GEN' ,-- Telephone PHONE_LINE_TYPE
727: SUBSTR(Act_Assessment_rec.home_phone,1,3),
751: LAST_UPDATE_LOGIN
752: )
753: VALUES
754: (
755: IGS_AD_CONTACTS_INT_S.NEXTVAL,
756: l_interface_id,
757: 'PHONE', -- COMMUNICATION_TYPE
758: 'GEN' ,-- Telephone PHONE_LINE_TYPE
759: Act_Assessment_rec.home_phone,