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_ST_GEN_004 dependencies on IGS_PE_STATISTICS

Line 262: v_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;

258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;
259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;
260: v_teach_ci_sequence_number
261: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE DEFAULT NULL;
262: v_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
263: v_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
264: v_gse_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
266: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE DEFAULT NULL;

Line 264: v_gse_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;

260: v_teach_ci_sequence_number
261: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE DEFAULT NULL;
262: v_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
263: v_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
264: v_gse_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
266: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE DEFAULT NULL;
267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;

Line 282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;

278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;

Line 283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;

279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;
287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;

Line 284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;

280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;
287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;

Line 285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;

281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;
287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;

Line 872: FROM IGS_PE_STATISTICS ps

868: WHERE pe.person_id = p_current_person_id;
869: CURSOR c_prsn_stats IS
870: SELECT ps.citizenship_cd,
871: ps.perm_resident_cd
872: FROM IGS_PE_STATISTICS ps
873: WHERE ps.person_id = p_current_person_id AND
874: ps.start_dt <= p_effective_dt AND
875: (ps.end_dt IS NULL OR
876: ps.end_dt >= p_effective_dt)

Line 3099: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,

3095: gse.submission_number = 1 AND -- Government Enrolment only sub 1
3096: gse.person_id = cp_person_id AND
3097: gse.course_cd = cp_course_cd;
3098: CURSOR c_ps (
3099: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3100: cp_effective_dt IGS_PE_STATISTICS.start_dt%TYPE) IS
3101: SELECT NVL(ps.citizenship_cd, '9'),
3102: NVL(ps.perm_resident_cd, '9'),
3103: ps.prior_degree,

Line 3100: cp_effective_dt IGS_PE_STATISTICS.start_dt%TYPE) IS

3096: gse.person_id = cp_person_id AND
3097: gse.course_cd = cp_course_cd;
3098: CURSOR c_ps (
3099: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3100: cp_effective_dt IGS_PE_STATISTICS.start_dt%TYPE) IS
3101: SELECT NVL(ps.citizenship_cd, '9'),
3102: NVL(ps.perm_resident_cd, '9'),
3103: ps.prior_degree,
3104: ps.prior_post_grad

Line 3105: FROM IGS_PE_STATISTICS ps

3101: SELECT NVL(ps.citizenship_cd, '9'),
3102: NVL(ps.perm_resident_cd, '9'),
3103: ps.prior_degree,
3104: ps.prior_post_grad
3105: FROM IGS_PE_STATISTICS ps
3106: WHERE ps.person_id = cp_person_id AND
3107: ps.start_dt <= cp_effective_dt AND
3108: (ps.end_dt IS NULL OR
3109: ps.end_dt >= cp_effective_dt)

Line 3135: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,

3131: NVL(gsc.old_perm_resident_cd, -1) = NVL(cp_old_perm_resident_cd, -1) AND
3132: NVL(gsc.perm_resident_cd, -1) = NVL(cp_perm_resident_cd, -1) AND
3133: NVL(gsc.citizenship_cd, -1) = NVL(cp_citizenship_cd, -1);
3134: CURSOR c_ps2 (
3135: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3136: cp_old_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE,
3137: cp_old_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE,
3138: cp_old_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE) IS
3139: SELECT ps.last_updated_by,

Line 3136: cp_old_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE,

3132: NVL(gsc.perm_resident_cd, -1) = NVL(cp_perm_resident_cd, -1) AND
3133: NVL(gsc.citizenship_cd, -1) = NVL(cp_citizenship_cd, -1);
3134: CURSOR c_ps2 (
3135: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3136: cp_old_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE,
3137: cp_old_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE,
3138: cp_old_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE) IS
3139: SELECT ps.last_updated_by,
3140: ps.last_update_date

Line 3137: cp_old_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE,

3133: NVL(gsc.citizenship_cd, -1) = NVL(cp_citizenship_cd, -1);
3134: CURSOR c_ps2 (
3135: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3136: cp_old_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE,
3137: cp_old_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE,
3138: cp_old_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE) IS
3139: SELECT ps.last_updated_by,
3140: ps.last_update_date
3141: FROM IGS_PE_STATISTICS ps

Line 3138: cp_old_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE) IS

3134: CURSOR c_ps2 (
3135: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3136: cp_old_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE,
3137: cp_old_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE,
3138: cp_old_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE) IS
3139: SELECT ps.last_updated_by,
3140: ps.last_update_date
3141: FROM IGS_PE_STATISTICS ps
3142: WHERE ps.person_id = cp_person_id AND

Line 3141: FROM IGS_PE_STATISTICS ps

3137: cp_old_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE,
3138: cp_old_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE) IS
3139: SELECT ps.last_updated_by,
3140: ps.last_update_date
3141: FROM IGS_PE_STATISTICS ps
3142: WHERE ps.person_id = cp_person_id AND
3143: ps.end_dt IS NOT NULL AND
3144: ps.perm_resident_cd = cp_old_perm_resident_cd AND
3145: ps.citizenship_cd = cp_old_citizenship_cd

Line 3148: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,

3144: ps.perm_resident_cd = cp_old_perm_resident_cd AND
3145: ps.citizenship_cd = cp_old_citizenship_cd
3146: ORDER BY ps.end_dt DESC;
3147: CURSOR c_ps3 (
3148: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3149: cp_effective_dt IGS_PE_STATISTICS.end_dt%TYPE) IS
3150: SELECT ps.last_updated_by,
3151: ps.last_update_date
3152: FROM IGS_PE_STATISTICS ps

Line 3149: cp_effective_dt IGS_PE_STATISTICS.end_dt%TYPE) IS

3145: ps.citizenship_cd = cp_old_citizenship_cd
3146: ORDER BY ps.end_dt DESC;
3147: CURSOR c_ps3 (
3148: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3149: cp_effective_dt IGS_PE_STATISTICS.end_dt%TYPE) IS
3150: SELECT ps.last_updated_by,
3151: ps.last_update_date
3152: FROM IGS_PE_STATISTICS ps
3153: WHERE ps.person_id = cp_person_id AND

Line 3152: FROM IGS_PE_STATISTICS ps

3148: cp_person_id IGS_PE_STATISTICS.person_id%TYPE,
3149: cp_effective_dt IGS_PE_STATISTICS.end_dt%TYPE) IS
3150: SELECT ps.last_updated_by,
3151: ps.last_update_date
3152: FROM IGS_PE_STATISTICS ps
3153: WHERE ps.person_id = cp_person_id AND
3154: ps.end_dt IS NOT NULL -- AND
3155: -- ps.end_dt > cp_effective_dt
3156: ORDER BY ps.end_dt DESC;

Line 3209: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;

3205: IGS_EN_ST_SNAPSHOT.govt_discipline_group_cd%TYPE;
3206: v_industrial_ind IGS_PS_UNIT_VER.industrial_ind%TYPE;
3207: v_old_cntr NUMBER;
3208: v_new_cntr NUMBER;
3209: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
3210: v_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE;
3211: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
3212: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3213: v_old_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;

Line 3210: v_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE;

3206: v_industrial_ind IGS_PS_UNIT_VER.industrial_ind%TYPE;
3207: v_old_cntr NUMBER;
3208: v_new_cntr NUMBER;
3209: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
3210: v_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE;
3211: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
3212: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3213: v_old_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3214: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

Line 3211: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;

3207: v_old_cntr NUMBER;
3208: v_new_cntr NUMBER;
3209: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
3210: v_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE;
3211: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
3212: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3213: v_old_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3214: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3215: -- declaration for rowid and the sequence number variable