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_AD_GEN_007 dependencies on IGS_CA_GEN_001

Line 444: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val

440: apcood.admission_cat = p_admission_cat AND
441: apcood.dt_alias = cp_appl_offer_resp_dt_alias;
442:
443: CURSOR c_daiv IS
444: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
445: FROM IGS_CA_DA_INST daiv,
446: IGS_AD_PERD_AD_CAT apac
447: WHERE daiv.dt_alias = v_appl_offer_resp_dt_alias AND
448: apac.adm_cal_type = p_adm_cal_type AND

Line 463: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val

459: apcood.dai_sequence_number = daiv.sequence_number)
460: ORDER BY 1 desc;
461:
462: CURSOR c_daiv2 IS
463: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
464: FROM IGS_CA_DA_INST daiv
465: WHERE daiv.cal_type = p_adm_cal_type AND
466: daiv.ci_sequence_number = p_adm_ci_sequence_number AND
467: daiv.dt_alias = v_appl_offer_resp_dt_alias AND