DBA Data[Home] [Help]

APPS.IGR_IMP_001 dependencies on DUAL

Line 31: SELECT igs_ad_interface_batch_id_s.nextval FROM dual;

27: null_validation_fails EXCEPTION;
28: date_validation_fails EXCEPTION;
29:
30: CURSOR batch_id_cur IS
31: SELECT igs_ad_interface_batch_id_s.nextval FROM dual;
32:
33: CURSOR interface_id_cur IS
34: SELECT igs_ad_interface_s.nextval FROM dual;
35:

Line 34: SELECT igs_ad_interface_s.nextval FROM dual;

30: CURSOR batch_id_cur IS
31: SELECT igs_ad_interface_batch_id_s.nextval FROM dual;
32:
33: CURSOR interface_id_cur IS
34: SELECT igs_ad_interface_s.nextval FROM dual;
35:
36: /* This Main Cursor retrieves all the Person and Inquiry Details,
37: with Status 'I' or 'U' which are then inserted
38: into IGS_AD_INTERFACE_ALL,IGS_AD_STAT_INT,IGS_PE_CITIZEN_INT and