APPS.IGS_FI_VAL_FCFL dependencies on IGS_FI_FEE_STR_STAT

Line 30: FROM IGS_FI_FEE_STR_STAT fss

26: v_dummy VARCHAR2(1);
27: CURSOR c_fss (
28: cp_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE) IS
29: SELECT 'x'
30: FROM IGS_FI_FEE_STR_STAT fss
31: WHERE fss.fee_structure_status = cp_fee_liability_status AND
32: fss.s_fee_structure_status = cst_active;
33: CURSOR c_cict (
34: cp_cal_type IGS_CA_INST.cal_type%TYPE,

Line 198: v_fss_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;

194: RETURN BOOLEAN AS
195: gv_other_detail VARCHAR2(255);
196: BEGIN
197: DECLARE
198: v_fss_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
199: cst_active_status CONSTANT VARCHAR2(6):= 'ACTIVE';
200: CURSOR c_ftci IS
201: SELECT fss.s_fee_structure_status
202: FROM IGS_FI_F_TYP_CA_INST ftci,

Line 203: IGS_FI_FEE_STR_STAT fss

199: cst_active_status CONSTANT VARCHAR2(6):= 'ACTIVE';
200: CURSOR c_ftci IS
201: SELECT fss.s_fee_structure_status
202: FROM IGS_FI_F_TYP_CA_INST ftci,
203: IGS_FI_FEE_STR_STAT fss
204: WHERE ftci.fee_cal_type = p_fee_cal_type AND
205: ftci.fee_ci_sequence_number = p_fee_ci_sequence_number AND
206: ftci.fee_type = p_fee_type AND
207: ftci.fee_type_ci_status = fss.fee_structure_status;

Line 210: FROM IGS_FI_FEE_STR_STAT fss

206: ftci.fee_type = p_fee_type AND
207: ftci.fee_type_ci_status = fss.fee_structure_status;
208: CURSOR c_fss IS
209: SELECT fss.s_fee_structure_status
210: FROM IGS_FI_FEE_STR_STAT fss
211: WHERE fss.fee_structure_status = p_fee_status;
212: CURSOR c_fcci IS
213: SELECT fss.s_fee_structure_status
214: FROM IGS_FI_F_CAT_CA_INST fcci,

Line 215: IGS_FI_FEE_STR_STAT fss

211: WHERE fss.fee_structure_status = p_fee_status;
212: CURSOR c_fcci IS
213: SELECT fss.s_fee_structure_status
214: FROM IGS_FI_F_CAT_CA_INST fcci,
215: IGS_FI_FEE_STR_STAT fss
216: WHERE fcci.fee_cal_type = p_fee_cal_type AND
217: fcci.fee_ci_sequence_number = p_fee_ci_sequence_number AND
218: fcci.fee_cat = p_fee_cat AND
219: fcci.fee_cat_ci_status = fss.fee_structure_status;