APPS.IGS_AD_GEN_008 dependencies on IGS_AD_FEE_STAT

Line 9: --Get the s_adm_fee_status for a specified IGS_AD_FEE_STAT.

5: p_adm_fee_status IN VARCHAR2 )
6: RETURN VARCHAR2 IS
7: gv_other_detail VARCHAR2(255);
8: BEGIN --admp_get_safs
9: --Get the s_adm_fee_status for a specified IGS_AD_FEE_STAT.
10: DECLARE
11: v_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE;
12: CURSOR c_afs IS
13: SELECT s_adm_fee_status

Line 11: v_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE;

7: gv_other_detail VARCHAR2(255);
8: BEGIN --admp_get_safs
9: --Get the s_adm_fee_status for a specified IGS_AD_FEE_STAT.
10: DECLARE
11: v_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE;
12: CURSOR c_afs IS
13: SELECT s_adm_fee_status
14: FROM IGS_AD_FEE_STAT
15: WHERE adm_fee_status = p_adm_fee_status;

Line 14: FROM IGS_AD_FEE_STAT

10: DECLARE
11: v_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE;
12: CURSOR c_afs IS
13: SELECT s_adm_fee_status
14: FROM IGS_AD_FEE_STAT
15: WHERE adm_fee_status = p_adm_fee_status;
16: BEGIN
17: --initialise v_fee_status
18: v_fee_status := NULL;