DBA Data[Home] [Help]

APPS.IGS_EN_HESA_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 131: igs_en_stdnt_ps_att c

127: a.last_updated_by last_updated_by,
128: a.last_update_login last_update_login
129: FROM igs_he_ad_dtl a,
130: igs_ad_ps_appl_inst b,
131: igs_en_stdnt_ps_att c
132: WHERE a.person_id = b.person_id
133: AND a.admission_appl_number = b.admission_appl_number
134: AND a.nominated_course_cd = b.nominated_course_cd
135: AND a.sequence_number = b.sequence_number

Line 475: igs_en_stdnt_ps_att b

471: a.fee_band fee_band,
472: a.type_of_year,
473: a.fundability_cd
474: FROM igs_he_poous a,
475: igs_en_stdnt_ps_att b
476: WHERE a.course_cd = p_course_cd
477: AND a.crv_version_number = p_crv_version_number
478: AND a.unit_set_cd = p_old_unit_set_cd
479: AND a.us_version_number = p_old_us_version_number

Line 498: igs_en_stdnt_ps_att b

494: a.fee_band fee_band,
495: a.type_of_year,
496: a.fundability_cd
497: FROM igs_he_poous a,
498: igs_en_stdnt_ps_att b
499: WHERE a.course_cd = p_course_cd
500: AND a.crv_version_number = p_crv_version_number
501: AND a.unit_set_cd = p_new_unit_set_cd
502: AND a.us_version_number = p_new_us_version_number

Line 1110: igs_en_stdnt_ps_att sca,

1106: CURSOR cur_grd_sch_grade IS
1107: SELECT 'x'
1108: FROM igs_as_grd_sch_grade gsg,
1109: igs_he_poous_all poous,
1110: igs_en_stdnt_ps_att sca,
1111: igs_as_su_setatmpt susa
1112: WHERE gsg.grading_schema_cd = poous.grading_schema_cd AND
1113: gsg.version_number = poous.gs_version_number AND
1114: gsg.grade = p_grad_sch_grade AND