APPS.IGS_AD_GEN_008 dependencies on IGS_AD_OU_STAT

Line 93: --Get the s_adm_outcome_status for a specified IGS_AD_OU_STAT.

89: p_adm_outcome_status IN VARCHAR2 )
90: RETURN VARCHAR2 IS
91: gv_other_detail VARCHAR2(255);
92: --admp_get_saos
93: --Get the s_adm_outcome_status for a specified IGS_AD_OU_STAT.
94: v_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
95: CURSOR c_aos IS
96: SELECT s_adm_outcome_status
97: FROM IGS_AD_OU_STAT

Line 94: v_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;

90: RETURN VARCHAR2 IS
91: gv_other_detail VARCHAR2(255);
92: --admp_get_saos
93: --Get the s_adm_outcome_status for a specified IGS_AD_OU_STAT.
94: v_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
95: CURSOR c_aos IS
96: SELECT s_adm_outcome_status
97: FROM IGS_AD_OU_STAT
98: WHERE adm_outcome_status = p_adm_outcome_status;

Line 97: FROM IGS_AD_OU_STAT

93: --Get the s_adm_outcome_status for a specified IGS_AD_OU_STAT.
94: v_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
95: CURSOR c_aos IS
96: SELECT s_adm_outcome_status
97: FROM IGS_AD_OU_STAT
98: WHERE adm_outcome_status = p_adm_outcome_status;
99: BEGIN
100: --initialise v_outcome_status
101: v_outcome_status := NULL;