APPS.BEN_IRC_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 68: function offer_assignment_rec_change(p_offer_assignment_rec_old in per_all_assignments_f%rowtype,

64: offer_assignment_rec_change function compares the two structures.
65: returns true if there is any change
66: returns false, otherwise
67: **/
68: function offer_assignment_rec_change(p_offer_assignment_rec_old in per_all_assignments_f%rowtype,
69: p_offer_assignment_rec_new in per_all_assignments_f%rowtype)
70: return boolean is
71:
72: begin

Line 69: p_offer_assignment_rec_new in per_all_assignments_f%rowtype)

65: returns true if there is any change
66: returns false, otherwise
67: **/
68: function offer_assignment_rec_change(p_offer_assignment_rec_old in per_all_assignments_f%rowtype,
69: p_offer_assignment_rec_new in per_all_assignments_f%rowtype)
70: return boolean is
71:
72: begin
73: --dbms_output.put_line('Entering offer');

Line 201: p_offer_assignment_rec_old in per_all_assignments_f%rowtype,

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:
205: --

Line 202: p_offer_assignment_rec_new in per_all_assignments_f%rowtype

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:
205: --
206: l_proc varchar2(80) := 'benutils.run_irc_benmngle_flag';

Line 220: from per_all_assignments_f

216: where person_id = p_person_id
217: and business_group_id = p_business_group_id
218: union
219: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date
220: from per_all_assignments_f
221: where person_id = p_person_id
222: and business_group_id = p_business_group_id
223: union
224: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date

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