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_ALL

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 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 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