APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 9531: FROM igs_en_stdnt_ps_att_all sca,

9527: hspa.franch_out_arr_cd,
9528: hspa.employer_role_cd,
9529: hspa.franch_partner_cd,
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

Line 9648: igs_en_stdnt_ps_att_all sca

9644: igs_he_en_susa husa,
9645: igs_en_unit_set us,
9646: igs_en_unit_set_cat susc,
9647: igs_en_spa_awd_aim enawd,
9648: igs_en_stdnt_ps_att_all sca
9649: WHERE susa.person_id = sca.person_id
9650: AND susa.course_cd = sca.course_cd
9651: AND sca.person_id = enawd.person_id(+)
9652: AND sca.course_cd = enawd.course_cd(+)

Line 9835: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;

9831: tr.program_cd = cp_course_cd AND
9832: ca.start_dt BETWEEN cp_enrl_start_dt AND cp_enrl_end_dt
9833: ORDER BY ca.start_dt DESC;
9834: c_term_con_rec c_term_con%ROWTYPE ;
9835: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;
9836:
9837: -- smaddali added cursor for bug#3361317
9838: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
9839: SELECT party_number person_number