DBA Data[Home] [Help]

APPS.IGS_AD_AC_COMP dependencies on IGS_TR_TYPE

Line 66: igs_tr_type tt

62: ) IS
63: SELECT ti.tracking_id
64: FROM igs_ad_aplins_admreq aa,
65: igs_tr_item ti,
66: igs_tr_type tt
67: WHERE aa.person_id = p_person_id
68: AND aa.admission_appl_number = p_admission_appl_number
69: AND aa.sequence_number = p_sequence_number
70: AND aa.course_cd = p_course_cd

Line 82: igs_tr_type itt

78: ) IS
79: SELECT 'x'
80: FROM igs_tr_item iti,
81: igs_tr_status its,
82: igs_tr_type itt
83: WHERE iti.tracking_id = p_tracking_id
84: AND itt.tracking_type = iti.tracking_type
85: AND itt.s_tracking_type = 'ADM_PROCESSING'
86: AND its.tracking_status = iti.tracking_status