APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_PS_UNIT_VER_V

Line 25: g_ps_unit_ver_v igs_ps_unit_ver_v%ROWTYPE;

21: g_pe_person igs_pe_person%ROWTYPE;
22: g_pe_stat_v igs_pe_stat_v%ROWTYPE;
23: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;
24: g_he_st_unt_vs igs_he_st_unt_vs%ROWTYPE;
25: g_ps_unit_ver_v igs_ps_unit_ver_v%ROWTYPE;
26: g_default_pro VARCHAR2(1);
27: g_he_stdnt_dlhe igs_he_stdnt_dlhe%ROWTYPE ;
28: l_hesa_method igs_he_ex_rn_dat_fd.value%TYPE;
29: l_hesa_empcir igs_he_ex_rn_dat_fd.value%TYPE;

Line 10358: igs_ps_unit_ver_v b

10354: b.title,
10355: b.enrolled_credit_points,
10356: b.unit_level
10357: FROM igs_he_st_unt_vs a,
10358: igs_ps_unit_ver_v b
10359: WHERE a.unit_cd = b.unit_cd
10360: AND a.version_number = b.version_number
10361: AND a.unit_cd = p_unit_cd
10362: AND a.version_number = p_uv_version_number;