APPS.IGS_AD_AC_COMP dependencies on IGS_AD_APLINS_ADMREQ

Line 64: FROM igs_ad_aplins_admreq aa,

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

Line 77: p_tracking_id igs_ad_aplins_admreq.tracking_id%TYPE

73: AND tt.s_tracking_type = 'ADM_PROCESSING';
74:
75: -- Get the list of tracking steps for which the tracking status is 'COMPLETE'
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,