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

Line 248: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;

244: -- Derive the New To Higher Education value.
245: -- DEETYA element 924
246: DECLARE
247: v_ret_val NUMBER(1) DEFAULT 1;
248: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;
249: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
250: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
251: CURSOR c_ps IS
252: SELECT ps.prior_post_grad,

Line 249: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;

245: -- DEETYA element 924
246: DECLARE
247: v_ret_val NUMBER(1) DEFAULT 1;
248: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;
249: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
250: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
251: CURSOR c_ps IS
252: SELECT ps.prior_post_grad,
253: ps.prior_degree,

Line 250: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;

246: DECLARE
247: v_ret_val NUMBER(1) DEFAULT 1;
248: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;
249: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
250: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
251: CURSOR c_ps IS
252: SELECT ps.prior_post_grad,
253: ps.prior_degree,
254: ps.prior_subdeg_notafe

Line 255: FROM IGS_PE_STATISTICS ps

251: CURSOR c_ps IS
252: SELECT ps.prior_post_grad,
253: ps.prior_degree,
254: ps.prior_subdeg_notafe
255: FROM IGS_PE_STATISTICS ps
256: WHERE ps.person_id = p_person_id AND
257: TRUNC(ps.start_dt) <= TRUNC(SYSDATE) AND
258: (ps.end_dt IS NULL OR
259: TRUNC(ps.end_dt) >= TRUNC(SYSDATE))

Line 341: FROM IGS_PE_STATISTICS ps

337: ps.citizenship_cd,
338: ps.birth_country_cd,
339: ps.yr_arrival,
340: ps.home_language_cd
341: FROM IGS_PE_STATISTICS ps
342: WHERE ps.person_id = p_person_id AND
343: TRUNC(ps.start_dt) <= TRUNC(p_effective_dt)
344: ORDER BY ps.start_dt DESC;
345: v_aborig_torres_cd IGS_PE_STATISTICS.aborig_torres_cd%TYPE;

Line 345: v_aborig_torres_cd IGS_PE_STATISTICS.aborig_torres_cd%TYPE;

341: FROM IGS_PE_STATISTICS ps
342: WHERE ps.person_id = p_person_id AND
343: TRUNC(ps.start_dt) <= TRUNC(p_effective_dt)
344: ORDER BY ps.start_dt DESC;
345: v_aborig_torres_cd IGS_PE_STATISTICS.aborig_torres_cd%TYPE;
346: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
347: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
348: v_home_language_cd IGS_PE_STATISTICS.home_language_cd%TYPE;
349: CURSOR c_atc IS

Line 346: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;

342: WHERE ps.person_id = p_person_id AND
343: TRUNC(ps.start_dt) <= TRUNC(p_effective_dt)
344: ORDER BY ps.start_dt DESC;
345: v_aborig_torres_cd IGS_PE_STATISTICS.aborig_torres_cd%TYPE;
346: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
347: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
348: v_home_language_cd IGS_PE_STATISTICS.home_language_cd%TYPE;
349: CURSOR c_atc IS
350: SELECT atc.govt_aborig_torres_cd

Line 347: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;

343: TRUNC(ps.start_dt) <= TRUNC(p_effective_dt)
344: ORDER BY ps.start_dt DESC;
345: v_aborig_torres_cd IGS_PE_STATISTICS.aborig_torres_cd%TYPE;
346: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
347: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
348: v_home_language_cd IGS_PE_STATISTICS.home_language_cd%TYPE;
349: CURSOR c_atc IS
350: SELECT atc.govt_aborig_torres_cd
351: FROM IGS_PE_ABORG_TORESCD atc

Line 348: v_home_language_cd IGS_PE_STATISTICS.home_language_cd%TYPE;

344: ORDER BY ps.start_dt DESC;
345: v_aborig_torres_cd IGS_PE_STATISTICS.aborig_torres_cd%TYPE;
346: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
347: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
348: v_home_language_cd IGS_PE_STATISTICS.home_language_cd%TYPE;
349: CURSOR c_atc IS
350: SELECT atc.govt_aborig_torres_cd
351: FROM IGS_PE_ABORG_TORESCD atc
352: WHERE atc.aborig_torres_cd = v_aborig_torres_cd;

Line 521: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;

517: v_home_location IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
518: v_govt_home_location IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
519: v_term_location IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
520: v_govt_term_location IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
521: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
522: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
523: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
524: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
525: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;

Line 522: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;

518: v_govt_home_location IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
519: v_term_location IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
520: v_govt_term_location IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
521: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
522: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
523: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
524: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
525: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
526: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;

Line 523: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;

519: v_term_location IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
520: v_govt_term_location IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
521: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
522: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
523: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
524: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
525: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
526: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
527: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;

Line 524: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;

520: v_govt_term_location IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
521: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
522: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
523: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
524: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
525: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
526: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
527: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
528: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;

Line 525: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;

521: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
522: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
523: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
524: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
525: v_birth_country_cd IGS_PE_STATISTICS.birth_country_cd%TYPE;
526: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
527: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
528: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
529: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;

Line 566: FROM IGS_PE_STATISTICS ps

562: ps.prior_subdeg_tafe,
563: ps.prior_seced_tafe,
564: ps.prior_seced_school,
565: ps.prior_tafe_award
566: FROM IGS_PE_STATISTICS ps
567: WHERE ps.person_id = p_person_id AND
568: ps.start_dt <= p_effective_dt AND
569: (ps.end_dt IS NULL OR
570: ps.end_dt >= p_effective_dt)