DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_PE_STAT_V

Line 22: g_pe_stat_v igs_pe_stat_v%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;
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);

Line 9544: -- smaddali modified this cursor to remove join with igs_pe_stat_v for bug#3361317

9540: AND psv.course_cd = p_course_cd
9541: AND psv.version_number = p_crv_version_number
9542: AND psv.course_type = pst.course_type;
9543:
9544: -- smaddali modified this cursor to remove join with igs_pe_stat_v for bug#3361317
9545: -- jchin - bug 4950293
9546: CURSOR c_pers IS
9547: SELECT P.PARTY_NUMBER PERSON_NUMBER,
9548: P.PARTY_NAME PERSON_NAME,