APPS.IGS_FI_VAL_FT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

                SELECT  'x'
                FROM    IGS_FI_FEE_RET_SCHD frs
                WHERE   frs.fee_type    = cp_fee_type;

Line: 51

                SELECT 'X'
                FROM igs_fi_tp_ret_schd
                WHERE fee_type = cp_fee_type;

Line: 142

                SELECT  'x'
                FROM    IGS_FI_FEE_AS fa
                WHERE   fa.fee_type     = cp_fee_type;

Line: 178

                SELECT  'x'
                FROM    IGS_PS_TYPE_FEE_TRG ctft
                WHERE   ctft.fee_type   = cp_fee_type
                        AND logical_delete_dt IS NULL;

Line: 215

                SELECT  'x'
                FROM    IGS_PS_GRP_FEE_TRG cgft
                WHERE   cgft.fee_type   = cp_fee_type
                        AND logical_delete_dt IS NULL;

Line: 254

                SELECT  'x'
                FROM    IGS_PS_FEE_TRG cft
                WHERE   cft.fee_type    = cp_fee_type
                        AND logical_delete_dt IS NULL;

Line: 291

                SELECT  'x'
                FROM    IGS_FI_UNIT_FEE_TRG uft
                WHERE   uft.fee_type    = cp_fee_type
                        AND logical_delete_dt IS NULL;

Line: 327

                SELECT  'x'
                FROM    IGS_EN_UNITSETFEETRG usft
                WHERE   usft.fee_type   = cp_fee_type
                        AND logical_delete_dt IS NULL;

Line: 472

        SELECT  'x'
        FROM    IGS_FI_F_CAT_FEE_LBL
        WHERE   FEE_TYPE = cp_fee_type AND
                (s_chg_method_type IS NOT NULL OR
                rul_sequence_number IS NOT NULL);

Line: 479

        SELECT  'x'
        FROM    IGS_FI_FEE_RET_SCHD
        WHERE   FEE_TYPE = cp_fee_type AND
                s_relation_type = 'FCFL';

Line: 490

        SELECT  'x'
        FROM    IGS_FI_FEE_AS_RATE
        WHERE   FEE_TYPE = cp_fee_type AND
                s_relation_type = 'FCFL' AND
                logical_delete_dt IS NULL;

Line: 496

        SELECT  'x'
        FROM    IGS_FI_ELM_RANGE
        WHERE   FEE_TYPE = cp_fee_type AND
                s_relation_type = 'FCFL' AND
                logical_delete_dt IS NULL;