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.

[Home] [Help]

APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGS_PE_PERSON_TYPES

Line 3079: FROM igs_pe_person_types

3075: FROM igs_ad_cal_conf;
3076:
3077: CURSOR cur_person_type ( cp_sys_type VARCHAR2) IS
3078: SELECT person_type_code
3079: FROM igs_pe_person_types
3080: WHERE system_type = cp_sys_type
3081: AND closed_ind = 'N' ;
3082:
3083: l_sys_type VARCHAR2(30) ;

Line 3084: l_person_type igs_pe_person_types.person_type_code%TYPE;

3080: WHERE system_type = cp_sys_type
3081: AND closed_ind = 'N' ;
3082:
3083: l_sys_type VARCHAR2(30) ;
3084: l_person_type igs_pe_person_types.person_type_code%TYPE;
3085: l_inq_cal_type igs_ad_cal_conf.inq_cal_type%TYPE;
3086: l_rowid ROWID;
3087: l_adm_seq igs_ca_inst.sequence_number%TYPE;
3088: l_acad_cal_type igs_ca_type.cal_type%TYPE;

Line 8202: igs_pe_person_types pt

8198:
8199: CURSOR cur_ptyp_code IS
8200: SELECT COUNT(*)
8201: FROM igs_pe_typ_instances_all pti,
8202: igs_pe_person_types pt
8203: WHERE pti.person_id = p_person_id
8204: AND pti.person_type_code = pt.person_type_code
8205: AND SYSDATE BETWEEN pti.start_date and NVL(pti.end_date,SYSDATE)
8206: AND pt.system_type IN ('PROSPECT','APPLICANT','STUDENT')