APPS.IBY_TRXN_AMT_LMT_PKG SQL Statements

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

Line: 30

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

Line: 41

    SELECT NVL(sum(amount),0)
	FROM iby_trxn_summaries_all tx
	WHERE ((ci_ccNumber = instrNumber) OR (ci_ccNumHash = instrnum_hash))
	   AND reqdate >= ci_fromDate
           AND reqType = 'ORAPMTREQ'
	   AND (status IN (0,11,100,111))
           AND payeeid = ci_payeeid;

Line: 54

     SELECT NVL(sum(amount),0)
	FROM iby_trxn_summaries_all tx
	WHERE (ci_instrid = payerInstrid)
          AND reqdate >= ci_fromDate
          AND reqType = 'ORAPMTREQ'
          AND (status IN (0,11,100,111))
          AND payeeid = ci_payeeid;

Line: 82

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

Line: 108

        ** select the number of purchases after "fromDate" value
        */

        l_fromDate := sysdate;