[Home] [Help]
540: IGS_AD_INTERFACE_ALL
541: --> IGS_AD_ADDR_INT_ALL
542: ------> IGS_AD_ADDRUSAGE_INT_ALL -- akadam Bug# 4352471
543: --> IGS_AD_CONTACTS_INT_ALL
544: --> IGS_AD_API_INT_ALL
545: --> IGS_AD_TEST_INT
546: ------> IGS_AD_TEST_SEGS_INT
547: --> IGS_AD_ACADHIS_INT_ALL
548: ------> IGS_AD_TXCPT_INT_ALL
771:
772: IF (SUBSTR(Act_Assessment_rec.act_identifier,1,1) <> '-') THEN
773: -- Inserting SSN Person_id_type
774: INSERT
775: INTO IGS_AD_API_INT_ALL
776: (
777: INTERFACE_API_ID ,
778: INTERFACE_ID ,
779: PERSON_ID_TYPE ,
804: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id : 2 ' || l_interface_id);
805:
806: -- Inserting ACT Person_id_type
807: INSERT
808: INTO IGS_AD_API_INT_ALL
809: (
810: INTERFACE_API_ID ,
811: INTERFACE_ID ,
812: PERSON_ID_TYPE ,