eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GR_GEN_002 dependencies on IGS_GE_DATE

Line 144: TRUNC(SYSDATE) BETWEEN NVL(dai1.alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

140: dai2.ci_sequence_number = crd.grd_ci_sequence_number AND
141: dai2.dt_alias = crd.end_dt_alias AND
142: dai2.sequence_number = crd.end_dai_sequence_number AND
143: dai2.alias_val IS NOT NULL AND
144: TRUNC(SYSDATE) BETWEEN NVL(dai1.alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
145: NVL(dai2.alias_val, IGS_GE_DATE.IGSDATE('1900/01/01'))AND
146: crdp.grd_cal_type(+) = crd.grd_cal_type AND
147: crdp.grd_ci_sequence_number(+) = crd.grd_ci_sequence_number AND
148: (p_course_cd IS NULL OR

Line 145: NVL(dai2.alias_val, IGS_GE_DATE.IGSDATE('1900/01/01'))AND

141: dai2.dt_alias = crd.end_dt_alias AND
142: dai2.sequence_number = crd.end_dai_sequence_number AND
143: dai2.alias_val IS NOT NULL AND
144: TRUNC(SYSDATE) BETWEEN NVL(dai1.alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
145: NVL(dai2.alias_val, IGS_GE_DATE.IGSDATE('1900/01/01'))AND
146: crdp.grd_cal_type(+) = crd.grd_cal_type AND
147: crdp.grd_ci_sequence_number(+) = crd.grd_ci_sequence_number AND
148: (p_course_cd IS NULL OR
149: sca.course_cd = p_course_cd) AND

Line 162: (NVL(sca.course_rqrmnts_complete_dt, IGS_GE_DATE.IGSDATE('9998/01/01'))

158: sca.nominated_completion_perd = NVL(crdp.completion_period, 'NULL')) OR
159: (p_derived_completion = 'Y' AND
160: sca.derived_completion_yr = NVL(crdp.completion_year, 1900) AND
161: sca.derived_completion_perd = NVL(crdp.completion_period, ' ')) OR
162: (NVL(sca.course_rqrmnts_complete_dt, IGS_GE_DATE.IGSDATE('9998/01/01'))
163: BETWEEN NVL(crd.completion_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
164: NVL(crd.completion_end_date, IGS_GE_DATE.IGSDATE('9999/01/01'))) OR
165: (NVL(spaa.conferral_date, IGS_GE_DATE.IGSDATE('9998/01/01'))
166: BETWEEN NVL(crd.conferral_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND

Line 163: BETWEEN NVL(crd.completion_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND

159: (p_derived_completion = 'Y' AND
160: sca.derived_completion_yr = NVL(crdp.completion_year, 1900) AND
161: sca.derived_completion_perd = NVL(crdp.completion_period, ' ')) OR
162: (NVL(sca.course_rqrmnts_complete_dt, IGS_GE_DATE.IGSDATE('9998/01/01'))
163: BETWEEN NVL(crd.completion_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
164: NVL(crd.completion_end_date, IGS_GE_DATE.IGSDATE('9999/01/01'))) OR
165: (NVL(spaa.conferral_date, IGS_GE_DATE.IGSDATE('9998/01/01'))
166: BETWEEN NVL(crd.conferral_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
167: NVL(crd.conferral_end_date, IGS_GE_DATE.IGSDATE('9999/01/01')))) AND

Line 164: NVL(crd.completion_end_date, IGS_GE_DATE.IGSDATE('9999/01/01'))) OR

160: sca.derived_completion_yr = NVL(crdp.completion_year, 1900) AND
161: sca.derived_completion_perd = NVL(crdp.completion_period, ' ')) OR
162: (NVL(sca.course_rqrmnts_complete_dt, IGS_GE_DATE.IGSDATE('9998/01/01'))
163: BETWEEN NVL(crd.completion_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
164: NVL(crd.completion_end_date, IGS_GE_DATE.IGSDATE('9999/01/01'))) OR
165: (NVL(spaa.conferral_date, IGS_GE_DATE.IGSDATE('9998/01/01'))
166: BETWEEN NVL(crd.conferral_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
167: NVL(crd.conferral_end_date, IGS_GE_DATE.IGSDATE('9999/01/01')))) AND
168: sca.course_attempt_status IN (

Line 165: (NVL(spaa.conferral_date, IGS_GE_DATE.IGSDATE('9998/01/01'))

161: sca.derived_completion_perd = NVL(crdp.completion_period, ' ')) OR
162: (NVL(sca.course_rqrmnts_complete_dt, IGS_GE_DATE.IGSDATE('9998/01/01'))
163: BETWEEN NVL(crd.completion_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
164: NVL(crd.completion_end_date, IGS_GE_DATE.IGSDATE('9999/01/01'))) OR
165: (NVL(spaa.conferral_date, IGS_GE_DATE.IGSDATE('9998/01/01'))
166: BETWEEN NVL(crd.conferral_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
167: NVL(crd.conferral_end_date, IGS_GE_DATE.IGSDATE('9999/01/01')))) AND
168: sca.course_attempt_status IN (
169: cst_completed,

Line 166: BETWEEN NVL(crd.conferral_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND

162: (NVL(sca.course_rqrmnts_complete_dt, IGS_GE_DATE.IGSDATE('9998/01/01'))
163: BETWEEN NVL(crd.completion_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
164: NVL(crd.completion_end_date, IGS_GE_DATE.IGSDATE('9999/01/01'))) OR
165: (NVL(spaa.conferral_date, IGS_GE_DATE.IGSDATE('9998/01/01'))
166: BETWEEN NVL(crd.conferral_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
167: NVL(crd.conferral_end_date, IGS_GE_DATE.IGSDATE('9999/01/01')))) AND
168: sca.course_attempt_status IN (
169: cst_completed,
170: cst_enrolled ,

Line 167: NVL(crd.conferral_end_date, IGS_GE_DATE.IGSDATE('9999/01/01')))) AND

163: BETWEEN NVL(crd.completion_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
164: NVL(crd.completion_end_date, IGS_GE_DATE.IGSDATE('9999/01/01'))) OR
165: (NVL(spaa.conferral_date, IGS_GE_DATE.IGSDATE('9998/01/01'))
166: BETWEEN NVL(crd.conferral_start_date, IGS_GE_DATE.IGSDATE('9999/01/01')) AND
167: NVL(crd.conferral_end_date, IGS_GE_DATE.IGSDATE('9999/01/01')))) AND
168: sca.course_attempt_status IN (
169: cst_completed,
170: cst_enrolled ,
171: cst_inactive ,