APPS.IBY_PMT_AMOUNT_PKG SQL Statements

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

Line: 15

    select lower_limit, upper_limit, score
    from iby_irf_pmt_amount
    where ( ( payeeid is null and ci_payeeid is null ) or
          payeeid = ci_payeeid)
    order by seq;

Line: 30

        select count(1) into l_cnt
        from iby_irf_pmt_amount
        where payeeid = i_payeeid;