DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_INTERFACE_CTL_S

Line 287: -- Cursor selecte a value from Sequence,IGS_AD_INTERFACE_CTL_S */

283: AND system_default = 'Y'
284: AND class_type_code = 'ADM_CODE_CLASSES';
285: cur_pending_reason_rec cur_pending_reason%ROWTYPE ;
286:
287: -- Cursor selecte a value from Sequence,IGS_AD_INTERFACE_CTL_S */
288: CURSOR cur_interface_ctl_s IS
289: SELECT igs_ad_interface_ctl_s.NEXTVAL
290: FROM DUAL ;
291:

Line 289: SELECT igs_ad_interface_ctl_s.NEXTVAL

285: cur_pending_reason_rec cur_pending_reason%ROWTYPE ;
286:
287: -- Cursor selecte a value from Sequence,IGS_AD_INTERFACE_CTL_S */
288: CURSOR cur_interface_ctl_s IS
289: SELECT igs_ad_interface_ctl_s.NEXTVAL
290: FROM DUAL ;
291:
292: -- to get all the distinct system_codes belonging to the passed application choice parameter
293: CURSOR c_ch_system IS