APPS.IBY_FACTOR_PKG dependencies on IBY_IRF_PMT_HIST_RANGE

Line 575: delete from iby_irf_pmt_hist_range

571: -- the database.
572: -- delete all the entries corresoonding to
573: -- l_pmt_hist_id and then insert the new ranges.
574:
575: delete from iby_irf_pmt_hist_range
576: where payment_hist_id = l_pmt_hist_id;
577:
578: while ( i <= i_count ) loop
579:

Line 588: insert into iby_irf_pmt_hist_range

584: l_score := i_freqRanges(i).score;
585: i := i+1;
586:
587: -- insert the ranges into database based on the sequence.
588: insert into iby_irf_pmt_hist_range
589: ( payment_hist_id, frequency_low_range,
590: frequency_high_range, score, seq,
591: object_version_number,
592: last_update_date, last_updated_by,

Line 661: from iby_irf_pmt_hist_range

657: ( payeeid = ci_payeeid));
658:
659: cursor c_load_ranges(ci_id integer) is
660: select frequency_low_range, frequency_high_range, score, seq
661: from iby_irf_pmt_hist_range
662: where payment_hist_id = ci_id
663: order by seq;
664:
665: cursor c_pmt_history_count(ci_payeeid varchar2) is