APPS.IGS_ADMAPPLICATION_PUB dependencies on IGS_AD_OU_STAT

Line 83: igs_ad_ou_stat c

79: SELECT
80: a.*
81: FROM
82: igs_ad_ps_appl_inst a,
83: igs_ad_ou_stat c
84: WHERE a.person_id = p_person_id
85: AND a.admission_appl_number = p_admission_appl_number
86: AND a.nominated_course_cd = p_nominated_course_cd
87: AND a.sequence_number = p_sequence_number

Line 505: l_s_adm_outcome_status igs_ad_ou_Stat.s_adm_outcome_status%TYPE;

501: l_adm_otcm_status_auth_per_num hz_parties.party_number%TYPE;
502: l_adm_outcome_status_reason igs_ad_ps_appl_inst.adm_outcome_status_reason%TYPE;
503:
504: l_uc_tran_id igs_uc_transactions.uc_tran_id%TYPE;
505: l_s_adm_outcome_status igs_ad_ou_Stat.s_adm_outcome_status%TYPE;
506:
507: l_req_for_reconsideration_ind VARCHAR2(1);
508: v_message_name VARCHAR2(2000);
509:

Line 2122: igs_ad_ou_stat c

2118: SELECT
2119: a.*
2120: FROM
2121: igs_ad_ps_appl_inst a,
2122: igs_ad_ou_stat c
2123: WHERE a.person_id = p_person_id
2124: AND a.admission_appl_number = p_admission_appl_number
2125: AND a.nominated_course_cd = p_nominated_course_cd
2126: AND a.sequence_number = p_sequence_number