APPS.FV_CST_GL SQL Statements

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

Line: 28

    select count('should be exactly four rows')
    into temp_count
    from gl_interface
    where reference25 IN (to_char(p_Receipt_id),to_char(p_Deliver_id))
    and group_id = p_group_id
    and actual_flag = 'A';

Line: 36

        delete
        from gl_interface
        where group_id = p_group_id
        and reference25 IN (to_char(p_Receipt_id),to_char(p_Deliver_id))
        and actual_flag = 'A'
        and code_combination_id = (
            select code_combination_id
            from gl_interface
            where reference25 IN (to_char(p_Receipt_id),to_char(p_Deliver_id))
            and group_id = p_group_id
            and actual_flag = 'A'
            group by code_combination_id
            having count(code_combination_id) = 2);