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_012 dependencies on IGS_AD_PRD_AD_PRC_CA

Line 527: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,

523: daiv.ci_sequence_number = ci.sequence_number
524: ORDER BY
525: ci.start_dt;
526: CURSOR c_apapc (
527: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
528: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE) IS
529:
530: SELECT aa.admission_cat,
531: aa.s_admission_process_type,

Line 528: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE) IS

524: ORDER BY
525: ci.start_dt;
526: CURSOR c_apapc (
527: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
528: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE) IS
529:
530: SELECT aa.admission_cat,
531: aa.s_admission_process_type,
532: aa.person_id,

Line 541: AND EXISTS ( SELECT 'x' FROM igs_ad_prd_ad_prc_ca apapc

537: IGS_AD_APPL aa
538: WHERE aa.person_id = aca.person_id
539: AND aa.admission_appl_number = aca.admission_appl_number
540: AND aca.req_for_reconsideration_ind = 'Y'
541: AND EXISTS ( SELECT 'x' FROM igs_ad_prd_ad_prc_ca apapc
542: WHERE apapc.adm_cal_type = cp_adm_cal_type
543: AND apapc.adm_ci_sequence_number = cp_adm_ci_sequence_number
544: AND apapc.admission_cat = aa.admission_cat
545: AND apapc.s_admission_process_type = aa.s_admission_process_type