APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_TR_ITEM

Line 732: FROM igs_tr_item ti,

728: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
729: cp_adm_appl_number igs_en_stdnt_ps_att.adm_admission_appl_number%TYPE,
730: cp_adm_seq_number igs_en_stdnt_ps_att.adm_sequence_number%TYPE) IS
731: SELECT 'TRUE'
732: FROM igs_tr_item ti,
733: igs_tr_status ts
734: WHERE ts.tracking_status = ti.tracking_status
735: AND ts.s_tracking_status <> 'COMPLETE'
736: AND ti.tracking_id IN ( SELECT ad.tracking_id

Line 738: igs_tr_item ti,

734: WHERE ts.tracking_status = ti.tracking_status
735: AND ts.s_tracking_status <> 'COMPLETE'
736: AND ti.tracking_id IN ( SELECT ad.tracking_id
737: FROM igs_tr_type tt,
738: igs_tr_item ti,
739: igs_ad_aplins_admreq ad
740: WHERE tt.s_tracking_type = 'POST_ADMISSION'
741: AND ad.tracking_id = ti.tracking_id
742: AND ti.tracking_type = tt.tracking_type