APPS.BEN_IRC_UTIL dependencies on PER_PAY_PROPOSALS

Line 11: function pay_proposal_rec_change(p_pay_proposal_rec_old in per_pay_proposals%ROWTYPE,

7: pay_proposal_rec_change function compares the two structures.
8: returns true if there is any change
9: returns false, otherwise
10: **/
11: function pay_proposal_rec_change(p_pay_proposal_rec_old in per_pay_proposals%ROWTYPE,
12: p_pay_proposal_rec_new in per_pay_proposals%ROWTYPE) return boolean is
13: begin
14: -- dbms_output.put_line('Entering pay');
15:

Line 12: p_pay_proposal_rec_new in per_pay_proposals%ROWTYPE) return boolean is

8: returns true if there is any change
9: returns false, otherwise
10: **/
11: function pay_proposal_rec_change(p_pay_proposal_rec_old in per_pay_proposals%ROWTYPE,
12: p_pay_proposal_rec_new in per_pay_proposals%ROWTYPE) return boolean is
13: begin
14: -- dbms_output.put_line('Entering pay');
15:
16: if

Line 199: p_pay_proposal_rec_old in per_pay_proposals%ROWTYPE,

195: function is_benmngle_for_irec_reqd( p_person_id in number,
196: p_assignment_id in number,
197: p_business_group_id in number,
198: p_effective_date in date,
199: p_pay_proposal_rec_old in per_pay_proposals%ROWTYPE,
200: p_pay_proposal_rec_new in per_pay_proposals%ROWTYPE,
201: p_offer_assignment_rec_old in per_all_assignments_f%rowtype,
202: p_offer_assignment_rec_new in per_all_assignments_f%rowtype
203: ) return varchar2 is

Line 200: p_pay_proposal_rec_new in per_pay_proposals%ROWTYPE,

196: p_assignment_id in number,
197: p_business_group_id in number,
198: p_effective_date in date,
199: p_pay_proposal_rec_old in per_pay_proposals%ROWTYPE,
200: p_pay_proposal_rec_new in per_pay_proposals%ROWTYPE,
201: p_offer_assignment_rec_old in per_all_assignments_f%rowtype,
202: p_offer_assignment_rec_new in per_all_assignments_f%rowtype
203: ) return varchar2 is
204:

Line 235: from per_pay_proposals psl, per_all_assignments_f asn

231: where person_id = p_person_id
232: and business_group_id = p_business_group_id
233: union
234: select max(nvl(psl.last_update_date,p_pil_last_upd_date)) last_update_date
235: from per_pay_proposals psl, per_all_assignments_f asn
236: where psl.assignment_id = asn.assignment_id
237: and asn.person_id = p_person_id
238: and asn.business_group_id = p_business_group_id
239: union

Line 292: -- 1. if per_pay_proposals structure for Offer has chnged

288:
289: elsif l_pil_last_upd_date is not null
290: then
291: -- means irec has already been run , Then chk for following:
292: -- 1. if per_pay_proposals structure for Offer has chnged
293: -- 2. if per_all_assignment structure for Offer has chnged
294: -- 3. if any HR info abt the person has chnged.
295: --dbms_output.put_line('IREC for more than one time');
296: if pay_proposal_rec_change(p_pay_proposal_rec_old,p_pay_proposal_rec_new) then