APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_ST_PROG

Line 16: g_he_st_prog igs_he_st_prog%ROWTYPE;

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;
18: g_he_poous igs_he_poous%ROWTYPE;
19: g_pe_person igs_pe_person%ROWTYPE;
20: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;

Line 1074: igs_he_st_prog_all hprog,

1070: enawd.complete_ind,
1071: enawd.conferral_date
1072: FROM igs_en_stdnt_ps_att_all sca,
1073: igs_he_st_spa_all hspa,
1074: igs_he_st_prog_all hprog,
1075: igs_en_spa_awd_aim enawd,
1076: hz_parties pe
1077: WHERE sca.person_id = hspa.person_id
1078: AND sca.course_cd = hspa.course_cd

Line 1200: igs_he_st_prog hpr,

1196: hpud.credit_value_yop1,
1197: hpud.fte_intensity ,
1198: hpud.funding_source
1199: FROM igs_ps_ver crv,
1200: igs_he_st_prog hpr,
1201: igs_he_poous hpud
1202: WHERE crv.course_cd = hpr.course_cd
1203: AND crv.version_number = hpr.version_number
1204: AND crv.course_cd = p_course_cd

Line 1887: igs_he_st_prog c

1883: IS
1884: SELECT DISTINCT Nvl(a.override_value, a.value) module_id
1885: FROM igs_he_ex_rn_dat_fd a,
1886: igs_he_ex_rn_dat_ln b,
1887: igs_he_st_prog c
1888: WHERE a.extract_run_id = b.extract_run_id
1889: AND b.extract_run_id = p_stdnt_extract_run_id
1890: AND b.course_cd = c.course_cd
1891: AND b.crv_version_number = c.version_number