DBA Data[Home] [Help]

APPS.IBY_PMT_AMOUNT_PKG dependencies on IBY_IRF_PMT_AMOUNT

Line 16: from iby_irf_pmt_amount

12: l_payeeid varchar2(80);
13:
14: cursor c_getfactor_config(ci_payeeid varchar2) is
15: select lower_limit, upper_limit, score
16: from iby_irf_pmt_amount
17: where ( ( payeeid is null and ci_payeeid is null ) or
18: payeeid = ci_payeeid)
19: order by seq;
20:

Line 31: from iby_irf_pmt_amount

27: ** if not the set payeeid to null.
28: */
29:
30: select count(1) into l_cnt
31: from iby_irf_pmt_amount
32: where payeeid = i_payeeid;
33:
34: if ( l_cnt = 0 ) then
35: l_payeeid := null;