APPS.IBY_FACTOR_PKG dependencies on IBY_IRF_PMT_AMOUNT

Line 41: delete from iby_irf_pmt_amount

37: -- loop through the list of ranges passed and update
38: -- the database.
39: -- delete all the entries first.
40:
41: delete from iby_irf_pmt_amount
42: where ((payeeid = i_payeeid)
43: or (i_payeeid is null and payeeid is null));
44:
45:

Line 56: insert into iby_irf_pmt_amount

52: l_seq := i_amountRanges(i).Seq;
53: l_score := i_amountRanges(i).score;
54: i := i+1;
55:
56: insert into iby_irf_pmt_amount
57: (lower_limit, upper_limit, score, seq,
58: payeeid, object_version_number,
59: last_update_date, last_updated_by, creation_date, created_by)
60: values ( l_lowerLimit, l_upperLimit, l_score, l_seq,

Line 111: from iby_irf_pmt_amount

107: --(lookup_type,view_application_id);
108:
109: cursor c_load_ranges(ci_payeeid VARCHAR2) is
110: select lower_limit, upper_limit, seq, score
111: from iby_irf_pmt_amount
112: where (( payeeid is null and ci_payeeid is null ) or
113: ( payeeid = ci_payeeid))
114: order by seq;
115:

Line 118: from iby_irf_pmt_amount

114: order by seq;
115:
116: cursor c_payee_range_count(ci_payeeid VARCHAR2) is
117: select count(*)
118: from iby_irf_pmt_amount
119: where payeeid = ci_payeeid;
120:
121: begin
122: