APPS.IGS_AD_GEN_009 dependencies on IGS_AD_UNIT_OU_STAT

Line 259: v_adm_outcome_status IGS_AD_UNIT_OU_STAT.adm_unit_outcome_status%TYPE;

255: --return the user-defined system default admission unit outcome status
256: --for a given system admission unit outcome status.
257: DECLARE
258: v_auos_cnt NUMBER DEFAULT 0;
259: v_adm_outcome_status IGS_AD_UNIT_OU_STAT.adm_unit_outcome_status%TYPE;
260: CURSOR c_auos IS
261: SELECT auos.adm_unit_outcome_status
262: FROM IGS_AD_UNIT_OU_STAT auos
263: WHERE s_adm_outcome_status = p_s_adm_outcome_status AND

Line 262: FROM IGS_AD_UNIT_OU_STAT auos

258: v_auos_cnt NUMBER DEFAULT 0;
259: v_adm_outcome_status IGS_AD_UNIT_OU_STAT.adm_unit_outcome_status%TYPE;
260: CURSOR c_auos IS
261: SELECT auos.adm_unit_outcome_status
262: FROM IGS_AD_UNIT_OU_STAT auos
263: WHERE s_adm_outcome_status = p_s_adm_outcome_status AND
264: system_default_ind = 'Y' AND
265: closed_ind = 'N';
266: BEGIN