DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on DUAL

Line 290: FROM DUAL ;

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
294: SELECT DISTINCT a.system_code, a.entry_year, a.entry_month

Line 1645: FROM dual ;

1641:
1642: -- Cursor to fetch the value from the sequence for inserting a record into IGS_AD_OFFRESP_BATCH table
1643: CURSOR cur_offresp_batc_s IS
1644: SELECT igs_ad_offresp_batch_s.NEXTVAL
1645: FROM dual ;
1646:
1647: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
1648: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
1649: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,