DBA Data[Home] [Help]

APPS.IGS_AD_TI_COMP dependencies on IGS_TR_STATUS

Line 562: igs_tr_status ts

558: ) IS
559: SELECT aa.tracking_id
560: FROM igs_ad_aplins_admreq aa,
561: igs_tr_item ti,
562: igs_tr_status ts
563: WHERE aa.person_id = p_person_id
564: AND aa.admission_appl_number = p_admission_appl_number
565: AND aa.sequence_number = p_sequence_number
566: AND aa.course_cd = p_course_cd

Line 731: igs_tr_status ts

727: p_sequence_number IN igs_ad_aplins_admreq.sequence_number%TYPE ) IS
728: SELECT 1
729: FROM igs_ad_aplins_admreq aa,
730: igs_tr_item ti,
731: igs_tr_status ts
732: WHERE aa.person_id = p_person_id
733: AND aa.admission_appl_number = p_admission_appl_number
734: AND aa.course_cd = p_course_cd
735: AND aa.sequence_number = p_sequence_number