[Home] [Help]
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:
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