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_SS_APPL_PGS_PKG dependencies on IGS_SS_ADM_APPL_STG

Line 632: FROM IGS_SS_ADM_APPL_STG

628: || (reverse chronological order - newest change first)
629: */
630: CURSOR c_get_incomplete_appl_data IS
631: SELECT ss_adm_appl_id, person_id, admission_application_type
632: FROM IGS_SS_ADM_APPL_STG
633: WHERE admission_application_type = p_admission_application_type;
634:
635: CURSOR c_get_section_status(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE,cp_appl_id igs_ss_adm_appl_stg.ss_adm_appl_id%TYPE,cp_section_name igs_ad_ss_appl_pgs.page_name%TYPE) IS
636: SELECT section, completion_status

Line 635: CURSOR c_get_section_status(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE,cp_appl_id igs_ss_adm_appl_stg.ss_adm_appl_id%TYPE,cp_section_name igs_ad_ss_appl_pgs.page_name%TYPE) IS

631: SELECT ss_adm_appl_id, person_id, admission_application_type
632: FROM IGS_SS_ADM_APPL_STG
633: WHERE admission_application_type = p_admission_application_type;
634:
635: CURSOR c_get_section_status(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE,cp_appl_id igs_ss_adm_appl_stg.ss_adm_appl_id%TYPE,cp_section_name igs_ad_ss_appl_pgs.page_name%TYPE) IS
636: SELECT section, completion_status
637: FROM IGS_SS_AD_SEC_STAT
638: WHERE ss_adm_appl_id=cp_appl_id
639: AND person_id=cp_person_id