APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_ST_UNT_VS

Line 24: g_he_st_unt_vs igs_he_st_unt_vs%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;
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;

Line 8245: l_fte_prop igs_he_st_unt_vs.proportion_of_fte%TYPE ;

8241: Modified fields: 12
8242: Created fields: 21-26
8243: ***************************************************************/
8244: l_message VARCHAR2(2000);
8245: l_fte_prop igs_he_st_unt_vs.proportion_of_fte%TYPE ;
8246: l_prop_not_taught NUMBER ;
8247:
8248: BEGIN
8249:

Line 10357: FROM igs_he_st_unt_vs a,

10353: a.location_cd ,
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