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_HE_EXTRACT2_PKG dependencies on IGS_HE_ST_SPA

Line 13: g_he_st_spa igs_he_st_spa%ROWTYPE;

9: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
10:
11: -- Student / Module related records.
12: g_en_stdnt_ps_att igs_en_stdnt_ps_att%ROWTYPE;
13: g_he_st_spa igs_he_st_spa%ROWTYPE;
14: g_as_su_setatmpt igs_as_su_setatmpt%ROWTYPE;
15: g_he_en_susa igs_he_en_susa%ROWTYPE;
16: g_he_st_prog igs_he_st_prog%ROWTYPE;
17: g_ps_ver igs_ps_ver%ROWTYPE;

Line 681: --If IGS_HE_ST_SPA_ALL.commencement date is NOT NULL then assign IGS_HE_ST_SPA_ALL.commencement date to p_value

677: p_field_number Field Number currently being processed.
678: p_value Calculated Value of the field.
679:
680: --changed the code for field 26 as a part of HECR002.
681: --If IGS_HE_ST_SPA_ALL.commencement date is NOT NULL then assign IGS_HE_ST_SPA_ALL.commencement date to p_value
682: --elsif IGS_HE_ST_SPA_ALL.commencement date IS NULL then check if program transfer has taken palce
683: --If program transfer has taken place then assign get the value of first program in chain for that person
684: --(For the person having the same student instance number for the different program transfer are said to be in same chain)
685: --and assign the corresponding IGS_EN_STDNT_PS_ATT.commencement_dt value to it

Line 682: --elsif IGS_HE_ST_SPA_ALL.commencement date IS NULL then check if program transfer has taken palce

678: p_value Calculated Value of the field.
679:
680: --changed the code for field 26 as a part of HECR002.
681: --If IGS_HE_ST_SPA_ALL.commencement date is NOT NULL then assign IGS_HE_ST_SPA_ALL.commencement date to p_value
682: --elsif IGS_HE_ST_SPA_ALL.commencement date IS NULL then check if program transfer has taken palce
683: --If program transfer has taken place then assign get the value of first program in chain for that person
684: --(For the person having the same student instance number for the different program transfer are said to be in same chain)
685: --and assign the corresponding IGS_EN_STDNT_PS_ATT.commencement_dt value to it
686: --else if the program transfer has not taken palce then get the IGS_EN_STDNT_PS_ATT.commencement_dt value

Line 749: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;

745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
748: l_fmly_name igs_pe_person.surname%TYPE;
749: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
750:
751: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)
752: IS
753: SELECT govt_field_of_study

Line 4610: --If IGS_HE_ST_SPA_ALL.commencement date is NOT NULL then assign IGS_HE_ST_SPA_ALL.commencement date to p_value

4606: p_field_number Field Number currently being processed.
4607: p_value Calculated Value of the field.
4608:
4609: --changed the code for field 26 as a part of HECR002.
4610: --If IGS_HE_ST_SPA_ALL.commencement date is NOT NULL then assign IGS_HE_ST_SPA_ALL.commencement date to p_value
4611: --elsif IGS_HE_ST_SPA_ALL.commencement date IS NULL then check if program transfer has taken palce
4612: --If program transfer has taken place then assign get the value of first program in chain for that person
4613: --(For the person having the same student instance number for the different program transfer are said to be in same chain)
4614: --and assign the corresponding IGS_EN_STDNT_PS_ATT.commencement_dt value to it

Line 4611: --elsif IGS_HE_ST_SPA_ALL.commencement date IS NULL then check if program transfer has taken palce

4607: p_value Calculated Value of the field.
4608:
4609: --changed the code for field 26 as a part of HECR002.
4610: --If IGS_HE_ST_SPA_ALL.commencement date is NOT NULL then assign IGS_HE_ST_SPA_ALL.commencement date to p_value
4611: --elsif IGS_HE_ST_SPA_ALL.commencement date IS NULL then check if program transfer has taken palce
4612: --If program transfer has taken place then assign get the value of first program in chain for that person
4613: --(For the person having the same student instance number for the different program transfer are said to be in same chain)
4614: --and assign the corresponding IGS_EN_STDNT_PS_ATT.commencement_dt value to it
4615: --else if the program transfer has not taken palce then get the IGS_EN_STDNT_PS_ATT.commencement_dt value

Line 4673: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;

4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
4672: l_fmly_name igs_pe_person.surname%TYPE;
4673: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
4674:
4675: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)
4676: IS
4677: SELECT govt_field_of_study

Line 9532: igs_he_st_spa_all hspa,

9528: hspa.employer_role_cd,
9529: hspa.franch_partner_cd,
9530: pst.course_type
9531: FROM igs_en_stdnt_ps_att_all sca,
9532: igs_he_st_spa_all hspa,
9533: igs_ps_ver_all psv,
9534: igs_ps_type_all pst
9535: WHERE sca.person_id = p_person_id
9536: AND sca.course_cd = p_course_cd