DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_PS_TYPE_ALL

Line 18: g_ps_type igs_ps_type_all%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;
18: g_ps_type igs_ps_type_all%ROWTYPE;
19: g_ps_ofr_opt igs_ps_ofr_opt%ROWTYPE;
20: g_he_poous igs_he_poous%ROWTYPE;
21: g_pe_person igs_pe_person%ROWTYPE;
22: g_pe_stat_v igs_pe_stat_v%ROWTYPE;

Line 9534: igs_ps_type_all pst

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
9537: AND sca.version_number = p_crv_version_number
9538: AND sca.person_id = hspa.person_id