APPS.IBY_TIME_OF_PURCHASE_PKG SQL Statements

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

Line: 21

    select duration_from, duration_to, score
    from iby_irf_timeof_purchase
    where ( ( payeeid is null and ci_payeeid is null ) or
          payeeid = ci_payeeid)
    order by seq;

Line: 36

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