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.IGS_ST_GEN_002 dependencies on IGS_ST_GOVT_STDNT_EN

Line 508: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;

504: gv_other_detail VARCHAR2(255);
505: BEGIN
506: DECLARE
507: v_other_detail VARCHAR2(255);
508: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
509: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
510: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
511: v_sex IGS_PE_PERSON.sex%TYPE;
512: v_govt_disability CHAR(8);

Line 509: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;

505: BEGIN
506: DECLARE
507: v_other_detail VARCHAR2(255);
508: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
509: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
510: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
511: v_sex IGS_PE_PERSON.sex%TYPE;
512: v_govt_disability CHAR(8);
513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;

Line 513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;

509: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
510: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
511: v_sex IGS_PE_PERSON.sex%TYPE;
512: v_govt_disability CHAR(8);
513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
517: v_home_location IGS_ST_GOVT_STDNT_EN.home_location%TYPE;

Line 514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;

510: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
511: v_sex IGS_PE_PERSON.sex%TYPE;
512: v_govt_disability CHAR(8);
513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%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;

Line 515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;

511: v_sex IGS_PE_PERSON.sex%TYPE;
512: v_govt_disability CHAR(8);
513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%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;

Line 516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;

512: v_govt_disability CHAR(8);
513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%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;

Line 517: v_home_location IGS_ST_GOVT_STDNT_EN.home_location%TYPE;

513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%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;

Line 518: v_govt_home_location IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;

514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%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;

Line 519: v_term_location IGS_ST_GOVT_STDNT_EN.term_location%TYPE;

515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%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;

Line 520: v_govt_term_location IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;

516: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%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;

Line 526: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%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;
530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;

Line 527: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%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;
530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;

Line 528: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%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;
530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;

Line 529: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%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;
530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;

Line 530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%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;
530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;

Line 531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%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;
530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;

Line 532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%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;
530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;

Line 533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;

529: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
537: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;

Line 534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;

530: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
537: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
538: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;

Line 535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;

531: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
537: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
538: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
539: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;

Line 536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;

532: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
537: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
538: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
539: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
540: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

Line 537: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;

533: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
537: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
538: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
539: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
540: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
541: CURSOR c_get_person_dtls IS

Line 538: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;

534: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
537: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
538: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
539: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
540: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
541: CURSOR c_get_person_dtls IS
542: SELECT pe.birth_dt,

Line 539: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;

535: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
536: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
537: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
538: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
539: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
540: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
541: CURSOR c_get_person_dtls IS
542: SELECT pe.birth_dt,
543: pe.sex