APPS.IBY_FREQ_OF_PURCH_PKG dependencies on IBY_IRF_PMT_FREQUENCY

Line 30: FROM iby_irf_pmt_frequency

26: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;
27:
28: CURSOR c_get_config(ci_payeeid varchar2) IS
29: SELECT duration, duration_type, frequency
30: FROM iby_irf_pmt_frequency
31: WHERE ( payeeid = ci_payeeid )
32: OR ( payeeid is null and ci_payeeid is null);
33: --
34: -- get frequency of purchase for all

Line 88: from iby_irf_pmt_frequency

84: ** site level configuration will be retrieved.
85: */
86:
87: select count(1) into l_count
88: from iby_irf_pmt_frequency
89: where payeeid = i_payeeid;
90:
91: if ( l_count = 0 ) then
92: l_payeeid := null;