APPS.IGS_AD_ADM_REQ dependencies on IGS_TR_ITEM

Line 52: l_tracking_id igs_tr_item.tracking_id%TYPE;

48: p_originator_person IN NUMBER,
49: p_org_id IN NUMBER
50: ) AS
51:
52: l_tracking_id igs_tr_item.tracking_id%TYPE;
53: l_aplins_admreq_id igs_ad_aplins_admreq.aplins_admreq_id%TYPE;
54: l_message_name VARCHAR2(30);
55: l_found BOOLEAN;
56: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 458: igs_tr_item itt,

454: SELECT
455: ar.rowid, ar.tracking_id, itt.tracking_type
456: FROM
457: igs_ad_aplins_admreq ar,
458: igs_tr_item itt,
459: igs_tr_type tt
460: WHERE
461: ar.person_id = p_person_id AND
462: ar.admission_appl_number = p_admission_appl_number AND

Line 526: FROM igs_tr_item itt,

522: AND ar.admission_appl_number = p_admission_appl_number
523: AND ar.course_cd = p_program_code
524: AND ar.sequence_number = p_sequence_number
525: AND EXISTS ( SELECT 'X'
526: FROM igs_tr_item itt,
527: igs_tr_type tt
528: WHERE itt.tracking_id = ar.tracking_id
529: AND itt.tracking_type = tt.tracking_type
530: AND tt.s_tracking_type = p_requirements_type