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_AU_GEN_001 dependencies on IGS_GE_DATE

Line 30: cst_appl_dt, IGS_GE_DATE.igschar(aah.appl_dt),

26: CURSOR c_aah IS
27: SELECT
28: DECODE (
29: p_column_name,
30: cst_appl_dt, IGS_GE_DATE.igschar(aah.appl_dt),
31: cst_acad_cal_type, aah.acad_cal_type,
32: cst_acad_ci_sequence_number, TO_CHAR(aah.acad_ci_sequence_number),
33: cst_adm_cal_type, aah.adm_cal_type,
34: cst_adm_ci_sequence_number, TO_CHAR(aah.adm_ci_sequence_number),

Line 46: cst_appl_dt, IGS_GE_DATE.igschar(aah.appl_dt),

42: aah.admission_appl_number = p_admission_appl_number AND
43: aah.hist_start_dt >= p_hist_end_dt AND
44: DECODE (
45: p_column_name,
46: cst_appl_dt, IGS_GE_DATE.igschar(aah.appl_dt),
47: cst_acad_cal_type, aah.acad_cal_type,
48: cst_acad_ci_sequence_number, TO_CHAR(aah.acad_ci_sequence_number),
49: cst_adm_cal_type, aah.adm_cal_type,
50: cst_adm_ci_sequence_number, TO_CHAR(aah.adm_ci_sequence_number),

Line 232: IGS_GE_DATE.igschar(acaih.adm_outcome_status_auth_dt),

228: cst_adm_outcome_status, acaih.ADM_OUTCOME_STATUS,
229: cst_adm_otcm_stus_auth_prsn_id,
230: TO_CHAR(acaih.adm_otcm_status_auth_person_id),
231: cst_adm_outcome_status_auth_dt,
232: IGS_GE_DATE.igschar(acaih.adm_outcome_status_auth_dt),
233: cst_adm_outcome_status_reason, acaih.adm_outcome_status_reason,
234: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),
235: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),
236: cst_prpsd_commencement_dt,

Line 234: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),

230: TO_CHAR(acaih.adm_otcm_status_auth_person_id),
231: cst_adm_outcome_status_auth_dt,
232: IGS_GE_DATE.igschar(acaih.adm_outcome_status_auth_dt),
233: cst_adm_outcome_status_reason, acaih.adm_outcome_status_reason,
234: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),
235: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),
236: cst_prpsd_commencement_dt,
237: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),
238: cst_adm_cndtnl_offer_status, acaih.ADM_CNDTNL_OFFER_STATUS,

Line 235: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),

231: cst_adm_outcome_status_auth_dt,
232: IGS_GE_DATE.igschar(acaih.adm_outcome_status_auth_dt),
233: cst_adm_outcome_status_reason, acaih.adm_outcome_status_reason,
234: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),
235: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),
236: cst_prpsd_commencement_dt,
237: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),
238: cst_adm_cndtnl_offer_status, acaih.ADM_CNDTNL_OFFER_STATUS,
239: cst_cndtnl_offer_satisfied_dt,

Line 237: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),

233: cst_adm_outcome_status_reason, acaih.adm_outcome_status_reason,
234: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),
235: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),
236: cst_prpsd_commencement_dt,
237: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),
238: cst_adm_cndtnl_offer_status, acaih.ADM_CNDTNL_OFFER_STATUS,
239: cst_cndtnl_offer_satisfied_dt,
240: IGS_GE_DATE.igschar(acaih.cndtnl_offer_satisfied_dt),
241: cst_cndtnl_offer_must_be_stsfd, acaih.cndtnl_offer_must_be_stsfd_ind,

Line 240: IGS_GE_DATE.igschar(acaih.cndtnl_offer_satisfied_dt),

236: cst_prpsd_commencement_dt,
237: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),
238: cst_adm_cndtnl_offer_status, acaih.ADM_CNDTNL_OFFER_STATUS,
239: cst_cndtnl_offer_satisfied_dt,
240: IGS_GE_DATE.igschar(acaih.cndtnl_offer_satisfied_dt),
241: cst_cndtnl_offer_must_be_stsfd, acaih.cndtnl_offer_must_be_stsfd_ind,
242: cst_adm_offer_resp_status, acaih.ADM_OFFER_RESP_STATUS,
243: cst_actual_response_dt, IGS_GE_DATE.igschar(acaih.actual_response_dt),
244: cst_adm_offer_dfrmnt_status, acaih.ADM_OFFER_DFRMNT_STATUS,

Line 243: cst_actual_response_dt, IGS_GE_DATE.igschar(acaih.actual_response_dt),

239: cst_cndtnl_offer_satisfied_dt,
240: IGS_GE_DATE.igschar(acaih.cndtnl_offer_satisfied_dt),
241: cst_cndtnl_offer_must_be_stsfd, acaih.cndtnl_offer_must_be_stsfd_ind,
242: cst_adm_offer_resp_status, acaih.ADM_OFFER_RESP_STATUS,
243: cst_actual_response_dt, IGS_GE_DATE.igschar(acaih.actual_response_dt),
244: cst_adm_offer_dfrmnt_status, acaih.ADM_OFFER_DFRMNT_STATUS,
245: cst_deferred_adm_cal_type, acaih.deferred_adm_cal_type,
246: cst_defer_adm_ci_sequnc_num, TO_CHAR(acaih.deferred_adm_ci_sequence_num),
247: cst_deferred_tracking_id, TO_CHAR(acaih.deferred_tracking_id),

Line 288: IGS_GE_DATE.igschar(acaih.adm_outcome_status_auth_dt),

284: cst_adm_outcome_status, acaih.ADM_OUTCOME_STATUS,
285: cst_adm_otcm_stus_auth_prsn_id,
286: TO_CHAR(acaih.adm_otcm_status_auth_person_id),
287: cst_adm_outcome_status_auth_dt,
288: IGS_GE_DATE.igschar(acaih.adm_outcome_status_auth_dt),
289: cst_adm_outcome_status_reason, acaih.adm_outcome_status_reason,
290: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),
291: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),
292: cst_prpsd_commencement_dt,

Line 290: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),

286: TO_CHAR(acaih.adm_otcm_status_auth_person_id),
287: cst_adm_outcome_status_auth_dt,
288: IGS_GE_DATE.igschar(acaih.adm_outcome_status_auth_dt),
289: cst_adm_outcome_status_reason, acaih.adm_outcome_status_reason,
290: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),
291: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),
292: cst_prpsd_commencement_dt,
293: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),
294: cst_adm_cndtnl_offer_status, acaih.ADM_CNDTNL_OFFER_STATUS,

Line 291: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),

287: cst_adm_outcome_status_auth_dt,
288: IGS_GE_DATE.igschar(acaih.adm_outcome_status_auth_dt),
289: cst_adm_outcome_status_reason, acaih.adm_outcome_status_reason,
290: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),
291: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),
292: cst_prpsd_commencement_dt,
293: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),
294: cst_adm_cndtnl_offer_status, acaih.ADM_CNDTNL_OFFER_STATUS,
295: cst_cndtnl_offer_satisfied_dt,

Line 293: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),

289: cst_adm_outcome_status_reason, acaih.adm_outcome_status_reason,
290: cst_offer_dt, IGS_GE_DATE.igschar(acaih.offer_dt),
291: cst_offer_response_dt, IGS_GE_DATE.igschar(acaih.offer_response_dt),
292: cst_prpsd_commencement_dt,
293: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),
294: cst_adm_cndtnl_offer_status, acaih.ADM_CNDTNL_OFFER_STATUS,
295: cst_cndtnl_offer_satisfied_dt,
296: IGS_GE_DATE.igschar(acaih.cndtnl_offer_satisfied_dt),
297: cst_cndtnl_offer_must_be_stsfd, acaih.cndtnl_offer_must_be_stsfd_ind,

Line 296: IGS_GE_DATE.igschar(acaih.cndtnl_offer_satisfied_dt),

292: cst_prpsd_commencement_dt,
293: IGS_GE_DATE.igschar(acaih.prpsd_commencement_dt),
294: cst_adm_cndtnl_offer_status, acaih.ADM_CNDTNL_OFFER_STATUS,
295: cst_cndtnl_offer_satisfied_dt,
296: IGS_GE_DATE.igschar(acaih.cndtnl_offer_satisfied_dt),
297: cst_cndtnl_offer_must_be_stsfd, acaih.cndtnl_offer_must_be_stsfd_ind,
298: cst_adm_offer_resp_status, acaih.ADM_OFFER_RESP_STATUS,
299: cst_actual_response_dt, IGS_GE_DATE.igschar(acaih.actual_response_dt),
300: cst_adm_offer_dfrmnt_status, acaih.ADM_OFFER_DFRMNT_STATUS,

Line 299: cst_actual_response_dt, IGS_GE_DATE.igschar(acaih.actual_response_dt),

295: cst_cndtnl_offer_satisfied_dt,
296: IGS_GE_DATE.igschar(acaih.cndtnl_offer_satisfied_dt),
297: cst_cndtnl_offer_must_be_stsfd, acaih.cndtnl_offer_must_be_stsfd_ind,
298: cst_adm_offer_resp_status, acaih.ADM_OFFER_RESP_STATUS,
299: cst_actual_response_dt, IGS_GE_DATE.igschar(acaih.actual_response_dt),
300: cst_adm_offer_dfrmnt_status, acaih.ADM_OFFER_DFRMNT_STATUS,
301: cst_deferred_adm_cal_type, acaih.deferred_adm_cal_type,
302: cst_defer_adm_ci_sequnc_num, TO_CHAR(acaih.deferred_adm_ci_sequence_num),
303: cst_deferred_tracking_id, TO_CHAR(acaih.deferred_tracking_id),

Line 378: IGS_GE_DATE.igscharDT(acaiuh.rule_waived_dt),

374: cst_unit_mode, acaiuh.UNIT_MODE,
375: cst_adm_unit_outcome_status, acaiuh.ADM_UNIT_OUTCOME_STATUS,
376: cst_ass_tracking_id, TO_CHAR(acaiuh.ass_tracking_id),
377: cst_rule_waived_dt,
378: IGS_GE_DATE.igscharDT(acaiuh.rule_waived_dt),
379: cst_rule_waived_person_id, TO_CHAR(acaiuh.rule_waived_person_id),
380: cst_sup_unit_cd, acaiuh.sup_unit_cd,
381: cst_sup_uv_version_number, TO_CHAR(acaiuh.sup_uv_version_number))
382: FROM IGS_AD_PS_APINTUNTHS acaiuh

Line 402: IGS_GE_DATE.igscharDT(acaiuh.rule_waived_dt),

398: cst_unit_mode, acaiuh.UNIT_MODE,
399: cst_adm_unit_outcome_status, acaiuh.ADM_UNIT_OUTCOME_STATUS,
400: cst_ass_tracking_id, TO_CHAR(acaiuh.ass_tracking_id),
401: cst_rule_waived_dt,
402: IGS_GE_DATE.igscharDT(acaiuh.rule_waived_dt),
403: cst_rule_waived_person_id, TO_CHAR(acaiuh.rule_waived_person_id),
404: cst_sup_unit_cd, acaiuh.sup_unit_cd,
405: cst_sup_uv_version_number, TO_CHAR(acaiuh.sup_uv_version_number))
406: IS NOT NULL