APPS.IGS_AD_AC_COMP dependencies on IGS_TR_ITEM

Line 65: igs_tr_item ti,

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

Line 80: FROM igs_tr_item iti,

76: CURSOR cur_tr_itm(
77: p_tracking_id igs_ad_aplins_admreq.tracking_id%TYPE
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