DBA Data[Home] [Help]

APPS.IBY_TRXN_AMT_LMT_PKG dependencies on IBY_IRF_TRXN_AMT_LIMIT

Line 31: from iby_irf_trxn_amt_limit

27: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;
28:
29: cursor c_get_config(ci_payeeid varchar2) is
30: select duration, duration_type, amount
31: from iby_irf_trxn_amt_limit
32: where ( payeeid = ci_payeeid ) or
33: ( payeeid is null and ci_payeeid is null);
34:
35: CURSOR c_get_fop_instrnum(

Line 83: from iby_irf_trxn_amt_limit

79: close c_get_fop_instrid;
80: end if;
81:
82: select count(1) into l_count
83: from iby_irf_trxn_amt_limit
84: where payeeid = i_payeeid;
85:
86: if ( l_count = 0 ) then
87: l_payeeid := null;