APPS.IGS_AD_GEN_003 dependencies on IGS_AD_CD

Line 168: v_adm_cd IGS_AD_CD.admission_cd%TYPE;

164: BEGIN -- admp_get_ac_bfa
165: -- This module finds the user defined admission code and basis for
166: -- admission type from the admission code table.
167: DECLARE
168: v_adm_cd IGS_AD_CD.admission_cd%TYPE;
169: v_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE;
170: CURSOR c_aco IS
171: SELECT admission_cd,
172: basis_for_admission_type

Line 173: FROM IGS_AD_CD

169: v_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE;
170: CURSOR c_aco IS
171: SELECT admission_cd,
172: basis_for_admission_type
173: FROM IGS_AD_CD
174: WHERE tac_admission_cd = p_tac_admission_cd AND
175: closed_ind = 'N'
176: ORDER BY basis_for_admission_type ASC;
177: BEGIN