APPS.IGS_FI_VAL_CFAR SQL Statements

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

Line: 40

                SELECT  ft.s_fee_type,
                        ft.s_fee_trigger_cat
                FROM    IGS_FI_FEE_TYPE ft
                WHERE   ft.fee_type = p_fee_type;

Line: 45

               SELECT   'X'
               FROM     igs_en_stdnt_ps_att sca,
                        igs_fi_f_cat_fee_lbl fcfl,
                        igs_fi_fee_str_stat fsst
               WHERE    sca.person_id = p_person_id
               AND      sca.course_cd = p_course_cd
               AND      fcfl.fee_type = p_fee_type
               AND      fcfl.fee_cat = sca.fee_cat
               AND      fcfl.fee_liability_status = fsst.fee_structure_status
               AND      fsst.s_fee_structure_status = 'ACTIVE'
               UNION ALL
               SELECT   'X'
               FROM     igs_en_spa_terms spa,
                        igs_fi_f_cat_fee_lbl fcfl,
                        igs_fi_fee_str_stat fsst
               WHERE    spa.person_id = p_person_id
               AND      spa.program_cd = p_course_cd
               AND      fcfl.fee_type = p_fee_type
               AND      fcfl.fee_cat = spa.fee_cat
               AND      fcfl.fee_liability_status = fsst.fee_structure_status
               AND      fsst.s_fee_structure_status = 'ACTIVE';

Line: 125

                SELECT  cfar.start_dt,
                        cfar.end_dt
                FROM    IGS_FI_FEE_AS_RT        cfar
                WHERE   cfar.person_id = p_person_id AND
                        cfar.course_cd = p_course_cd AND
                        cfar.fee_type = p_fee_type AND
                        cfar.start_dt <> p_start_dt;

Line: 185

                SELECT  cfar.person_id
                FROM    IGS_FI_FEE_AS_RT        cfar
                WHERE   cfar.person_id = p_person_id AND
                        cfar.course_cd = p_course_cd AND
                        cfar.fee_type = p_fee_type AND
                        cfar.start_dt <> p_start_dt AND
                        cfar.end_dt IS NULL;

Line: 240

                SELECT  am.closed_ind
                FROM    IGS_EN_ATD_MODE am
                WHERE   am.attendance_mode = p_attendance_mode;

Line: 271

                SELECT  att.closed_ind
                FROM    IGS_EN_ATD_TYPE att
                WHERE   att.attendance_type = p_attendance_type;

Line: 303

                SELECT  loc.closed_ind,
                        loc.location_type
                FROM    IGS_AD_LOCATION loc
                WHERE   loc.location_cd = p_location_cd;

Line: 349

                SELECT  ft.closed_ind
                FROM    IGS_FI_FEE_TYPE ft
                WHERE   ft.fee_type = p_fee_type;