DBA Data[Home] [Help]

APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_EN_INTM_TYPES

Line 929: igs_en_intm_types eit

925: SELECT sci.person_id,sci.course_cd,start_dt, sci.end_dt, sci.voluntary_ind,sci.comments ,sci.created_by ,sci.creation_date ,
926: sci.last_updated_by ,sci.last_update_date , sci.last_update_login , sci.intermission_type , sci.approved ,sci.institution_name,
927: sci.max_credit_pts, sci.max_terms, sci.anticipated_credit_points, sci.approver_id
928: FROM igs_en_stdnt_ps_intm sci,
929: igs_en_intm_types eit
930: WHERE sci.course_cd = cp_course_cd
931: AND sci.person_id = cp_perosn_id
932: AND sci.approved = eit.appr_reqd_ind
933: AND eit.intermission_type = sci.intermission_type