DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_EN_USEC_DISC_DL

Line 96: FROM igs_en_usec_disc_dl

92: -- at the unit level for the logged on person and for the uoo_id passed
93: CURSOR cur_usec_disc_dl
94: IS
95: SELECT usec_disc_dl_date alias_val
96: FROM igs_en_usec_disc_dl
97: WHERE uoo_id = p_uoo_id
98: ORDER BY usec_disc_dl_date, administrative_unit_status;
99:
100: -- cursor for getting the date aliases that are defined

Line 343: FROM igs_en_usec_disc_dl

339: -- at the unit level for the logged on person and for the uoo_id passed
340: CURSOR cur_unit_usec_disc
341: IS
342: SELECT usec_disc_dl_date alias_val,administrative_unit_status
343: FROM igs_en_usec_disc_dl
344: WHERE uoo_id = p_uoo_id
345: ORDER BY usec_disc_dl_date;
346:
347: -- cursor for getting the date aliases that are defined