APPS.IGS_AD_VAL_AFS dependencies on IGS_AD_FEE_STAT

Line 52: v_sys_def_ind IGS_AD_FEE_STAT.system_default_ind%TYPE;

48: -- Check if another adm_fee_status record exists with the system
49: -- default indicator set to 'Y'
50: DECLARE
51: v_count_rec NUMBER;
52: v_sys_def_ind IGS_AD_FEE_STAT.system_default_ind%TYPE;
53: cst_yes CONSTANT CHAR := 'Y';
54: CURSOR c_count (cp_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE,
55: cp_s_adm_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE)IS
56: SELECT count(*),

Line 54: CURSOR c_count (cp_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE,

50: DECLARE
51: v_count_rec NUMBER;
52: v_sys_def_ind IGS_AD_FEE_STAT.system_default_ind%TYPE;
53: cst_yes CONSTANT CHAR := 'Y';
54: CURSOR c_count (cp_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE,
55: cp_s_adm_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE)IS
56: SELECT count(*),
57: system_default_ind
58: FROM IGS_AD_FEE_STAT afs

Line 55: cp_s_adm_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE)IS

51: v_count_rec NUMBER;
52: v_sys_def_ind IGS_AD_FEE_STAT.system_default_ind%TYPE;
53: cst_yes CONSTANT CHAR := 'Y';
54: CURSOR c_count (cp_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE,
55: cp_s_adm_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE)IS
56: SELECT count(*),
57: system_default_ind
58: FROM IGS_AD_FEE_STAT afs
59: WHERE afs.adm_fee_status <> cp_adm_fee_status AND

Line 58: FROM IGS_AD_FEE_STAT afs

54: CURSOR c_count (cp_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE,
55: cp_s_adm_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE)IS
56: SELECT count(*),
57: system_default_ind
58: FROM IGS_AD_FEE_STAT afs
59: WHERE afs.adm_fee_status <> cp_adm_fee_status AND
60: afs.s_adm_fee_status = cp_s_adm_fee_status AND
61: afs.system_default_ind = cst_yes
62: GROUP BY system_default_ind;