APPS.IBY_PMT_HISTORY_PKG SQL Statements

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

Line: 30

    select frequency_low_range lower_limit,
           frequency_high_range upper_limit, score
    from iby_irf_pmt_hist_range
    where payment_hist_id = ci_pmt_hist_id
    order by seq;

Line: 37

    select duration, duration_type, id
    from iby_irf_pmt_history
    where ( payeeid is null and ci_payeeid is null )
         or (payeeid = ci_payeeid);

Line: 54

    SELECT count(1)
    FROM iby_trxn_summaries_all
    WHERE ((instrnumber = ci_ccNum) OR (instrnum_hash = ci_ccNumHash))
       AND reqdate >= ci_fromDate
       AND reqtype = 'ORAPMTREQ'
       AND (status IN (0,11,10,111))
       AND (payeeid = ci_payeeid);

Line: 69

    SELECT count(1)
    FROM iby_trxn_summaries_all
    WHERE (payerid = ci_payerid)
       AND reqdate >= ci_fromDate
       AND reqtype = 'ORAPMTREQ'
       AND (status IN (0,11,10,111))
       AND (payeeid = ci_payeeid);

Line: 84

    SELECT count(1)
    FROM iby_trxn_summaries_all
    WHERE (payerinstrid = ci_instrid)
       AND reqdate >= ci_fromDate
       AND reqtype = 'ORAPMTREQ'
       AND (status IN (0,11,10,111))
       AND (payeeid = ci_payeeid);

Line: 109

        select count(1) into l_count
        from iby_irf_pmt_history
        where payeeid = i_payeeid;