APPS.IGS_HE_SUSA_LGCY_PUB dependencies on IGS_HE_EN_SUSA_S

Line 662: l_sequence_number igs_he_en_susa.sequence_number%TYPE;

658: l_insert_flag BOOLEAN := TRUE;
659: l_ret_val VARCHAR2(1) := NULL;
660:
661: l_person_id igs_he_en_susa.person_id%TYPE;
662: l_sequence_number igs_he_en_susa.sequence_number%TYPE;
663: l_us_version_number igs_he_en_susa.us_version_number%TYPE;
664: l_hesa_en_susa_id igs_he_en_susa.hesa_en_susa_id%TYPE;
665:
666: l_creation_date igs_he_en_susa.creation_date%TYPE;

Line 796: SELECT igs_he_en_susa_s.NEXTVAL

792: l_last_update_login := -1;
793: END IF;
794:
795: -- Derive HESA_EN_SUSA_ID from sequence
796: SELECT igs_he_en_susa_s.NEXTVAL
797: INTO l_hesa_en_susa_id
798: FROM dual;
799:
800: