APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_AD_APLINS_ADMREQ

Line 739: igs_ad_aplins_admreq ad

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
743: AND ad.person_id = cp_person_id