DBA Data[Home] [Help]

APPS.IGS_AD_TI_COMP dependencies on IGS_TR_ITEM

Line 561: igs_tr_item ti,

557: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
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

Line 730: igs_tr_item ti,

726: p_course_cd IN igs_ad_aplins_admreq.course_cd%TYPE ,
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