APPS.IBY_FACTOR_PKG dependencies on IBY_IRF_PMT_HISTORY

Line 527: from iby_irf_pmt_history

523: l_pmt_hist_id int;
524:
525: cursor c_pmtHistId(ci_payeeid varchar2) is
526: select id
527: from iby_irf_pmt_history
528: where (( payeeid is null and ci_payeeid is null ) or
529: ( payeeid = ci_payeeid));
530:
531:

Line 540: update iby_irf_pmt_history

536: -- Update the master table. If there are no rows to update
537: -- then insert the information. This happens only when
538: -- payeeid id is not null.
539:
540: update iby_irf_pmt_history
541: set duration = i_duration,
542: duration_type = i_durationType,
543: last_update_date = sysdate,
544: last_updated_by = fnd_global.user_id

Line 551: SELECT iby_irf_pmt_history_s.nextval into l_pmt_hist_id

547:
548: if ( SQL%ROWCOUNT = 0 ) then
549:
550: -- insert a row in master table.
551: SELECT iby_irf_pmt_history_s.nextval into l_pmt_hist_id
552: FROM dual;
553:
554: insert into iby_irf_pmt_history (id, duration, duration_type,
555: payeeid, object_version_number,

Line 554: insert into iby_irf_pmt_history (id, duration, duration_type,

550: -- insert a row in master table.
551: SELECT iby_irf_pmt_history_s.nextval into l_pmt_hist_id
552: FROM dual;
553:
554: insert into iby_irf_pmt_history (id, duration, duration_type,
555: payeeid, object_version_number,
556: last_update_date, last_updated_by, creation_date, created_by)
557: values ( l_pmt_hist_id, i_duration, i_durationType, i_payeeid,
558: 1, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

Line 655: from iby_irf_pmt_history

651:
652:
653: cursor c_load_pmt_history(ci_payeeid varchar2) is
654: select id, duration, duration_type
655: from iby_irf_pmt_history
656: where (( payeeid is null and ci_payeeid is null ) or
657: ( payeeid = ci_payeeid));
658:
659: cursor c_load_ranges(ci_id integer) is

Line 667: from iby_irf_pmt_history

663: order by seq;
664:
665: cursor c_pmt_history_count(ci_payeeid varchar2) is
666: select count(*)
667: from iby_irf_pmt_history
668: where payeeid = ci_payeeid;
669:
670: begin
671: