APPS.IBY_AVS_CODE_PKG SQL Statements

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

Line: 16

    select value
    from iby_mappings
    where ( ( payeeid is null and ci_payeeid is null ) or
          payeeid = ci_payeeid)
    and mapping_type = 'AVS_CODE_TYPE'
    and mapping_code = ci_avs_code;

Line: 31

        select count(1) into l_cnt
        from iby_mappings
        where mapping_type = 'AVS_CODE_TYPE'
        and payeeid = i_payeeid;