APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_TR_STATUS

Line 733: igs_tr_status ts

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
737: FROM igs_tr_type tt,