APPS.IBY_FREQ_OF_PURCH_PKG SQL Statements

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

Line: 29

	SELECT duration, duration_type, frequency
	FROM iby_irf_pmt_frequency
	WHERE ( payeeid = ci_payeeid )
	OR ( payeeid is null and ci_payeeid is null);

Line: 45

	SELECT count(1)
	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: 58

	SELECT count(1)
	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: 87

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

Line: 136

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

    	l_no_of_purchases := 0;