DBA Data[Home] [Help]

APPS.IBY_TIME_OF_PURCHASE_PKG dependencies on IBY_IRF_TIMEOF_PURCHASE

Line 22: from iby_irf_timeof_purchase

18:
19: cursor c_get_factor_config(ci_payeeid in varchar2) is
20:
21: select duration_from, duration_to, score
22: from iby_irf_timeof_purchase
23: where ( ( payeeid is null and ci_payeeid is null ) or
24: payeeid = ci_payeeid)
25: order by seq;
26:

Line 37: from iby_irf_timeof_purchase

33: ** if not the set payeeid to null.
34: */
35:
36: select count(1) into l_cnt
37: from iby_irf_timeof_purchase
38: where payeeid = i_payeeid;
39:
40: if ( l_cnt = 0 ) then
41: l_payeeid := null;