DBA Data[Home] [Help]

APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 117: CURSOR enrl_std_cur( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE) IS

113:
114: --Added the last two AND conditions as per the FACCR004 in Disbursement Build Jul 2002
115: --to differentiate between records having primary program as 'Y' and 'A' or 'E'
116: --Bug Id:2154941
117: CURSOR enrl_std_cur( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE) IS
118: SELECT course_cd, adm_admission_appl_number, version_number, commencement_dt, course_attempt_status, attendance_mode, location_cd
119: FROM igs_en_stdnt_ps_att
120: WHERE person_id = p_person_id
121: AND key_program = 'Y' ;

Line 300: igs_en_stdnt_ps_att_all ps

296: SELECT susa.unit_set_cd,susa.course_cd,susa.us_version_number
297: FROM igs_as_su_setatmpt susa,
298: igs_en_unit_set us ,
299: igs_en_unit_set_cat usc,
300: igs_en_stdnt_ps_att_all ps
301: WHERE susa.person_id = cp_person_id
302: AND ps.person_id = susa.person_id
303: AND susa.course_cd = ps.course_cd
304: AND ps.key_program = 'Y'