APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_APPL

Line 75: igs_ad_appl aa,

71: FROM
72: igs_ad_ps_appl_inst apai,
73: igs_ad_ou_stat aos,
74: igs_ad_doc_stat ads,
75: igs_ad_appl aa,
76: igs_ad_appl_stat aps
77: WHERE
78: -- known person
79: apai.person_id = nvl(p_person_id,apai.person_id) AND

Line 76: igs_ad_appl_stat aps

72: igs_ad_ps_appl_inst apai,
73: igs_ad_ou_stat aos,
74: igs_ad_doc_stat ads,
75: igs_ad_appl aa,
76: igs_ad_appl_stat aps
77: WHERE
78: -- known person
79: apai.person_id = nvl(p_person_id,apai.person_id) AND
80: -- known person id group

Line 124: igs_ad_appl aa,

120: FROM
121: igs_ad_ps_appl_inst apai,
122: igs_ad_ou_stat aos,
123: igs_ad_doc_stat ads,
124: igs_ad_appl aa,
125: igs_ad_appl_stat aps
126: WHERE
127: -- known person
128: apai.person_id = nvl(p_person_id,apai.person_id) AND

Line 125: igs_ad_appl_stat aps

121: igs_ad_ps_appl_inst apai,
122: igs_ad_ou_stat aos,
123: igs_ad_doc_stat ads,
124: igs_ad_appl aa,
125: igs_ad_appl_stat aps
126: WHERE
127: -- known person
128: apai.person_id = nvl(p_person_id,apai.person_id) AND
129: -- known person id group

Line 484: igs_ad_appl aa

480: aa.s_admission_process_type,
481: apai.crv_version_number
482: FROM
483: igs_ad_ps_appl_inst apai,
484: igs_ad_appl aa
485: WHERE
486: apai.person_id = aa.person_id AND
487: apai.admission_appl_number = aa.admission_appl_number AND
488: apai.person_id = p_person_id AND

Line 501: FROM igs_ad_appl aa,

497: FROM igs_tr_type ty
498: WHERE ty.s_tracking_type = p_requirements_type
499: AND ty.closed_ind = 'N'
500: AND EXISTS ( SELECT 'X'
501: FROM igs_ad_appl aa,
502: igs_ad_ps_appl_inst apai,
503: igs_ad_prcs_cat_step apcs
504: WHERE apai.person_id = p_person_id
505: AND apai.admission_appl_number = p_admission_appl_number