APPS.IGS_FI_VAL_FT dependencies on IGS_FI_F_CAT_FEE_LBL

Line 459: -- related IGS_FI_F_CAT_FEE_LBL records with SI_FI_S_CHG_MTH or

455: ----------------------------------------------------------------------------*/
456: BEGIN -- finp_val_ft_sftc
457: -- Validate changes to the IGS_FI_FEE_TYPE.s_fee_trigger_cat.
458: -- If changing to INSTITUTN from anything else ensure there are no
459: -- related IGS_FI_F_CAT_FEE_LBL records with SI_FI_S_CHG_MTH or
460: -- rule_sequence_number set.
461: -- If changing to INSTITUTN from anything else ensure there are no
462: -- related records at FCFL level for the following:
463: -- IGS_FI_FEE_PAY_SCHD

Line 473: FROM IGS_FI_F_CAT_FEE_LBL

469: DECLARE
470: v_dummy VARCHAR2(1);
471: CURSOR c_fee_cat_fee_liability (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
472: SELECT 'x'
473: FROM IGS_FI_F_CAT_FEE_LBL
474: WHERE FEE_TYPE = cp_fee_type AND
475: (s_chg_method_type IS NOT NULL OR
476: rul_sequence_number IS NOT NULL);
477: