APPS.PAY_IE_WNU_EDI dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 39: from per_assignment_extra_info aei

35: --
36: cursor csr_extra_info is
37: select aei.assignment_extra_info_id ,
38: object_version_number
39: from per_assignment_extra_info aei
40: where aei.assignment_id = p_assignment_id
41: and information_type = 'IE_WNU';
42: --
43: begin

Line 283: -- Update flag set in PER_ASSIGNMENT_EXTRA_INFO for this assignment

279:
280: --
281: hr_utility.set_location(l_proc,20);
282: --
283: -- Update flag set in PER_ASSIGNMENT_EXTRA_INFO for this assignment
284: hr_utility.trace('Updating AEI flag, for asg:'||to_char(l_stored_asg_id));
285: PAY_IE_WNU_EDI.wnu_update_extra_info
286: (p_assignment_id => asgrec.assignment_id,
287: p_effective_date => l_effective_date,

Line 325: per_assignment_extra_info aei,

321: from per_all_assignments_f asg,
322: pay_payroll_actions ppa,
323: per_all_people_f pap,
324: per_periods_of_service serv,
325: per_assignment_extra_info aei,
326: -- hr_organization_information hoi,
327: pay_all_payrolls_f pay,
328: hr_soft_coding_keyflex sck
329: where ppa.payroll_action_id = pactid

Line 441: -- Update flag set in PER_ASSIGNMENT_EXTRA_INFO for this assignment

437:
438: hr_utility.set_location(l_proc,20);
439: --
440: --
441: -- Update flag set in PER_ASSIGNMENT_EXTRA_INFO for this assignment
442: hr_utility.trace('Updating AEI flag, for asg:'||to_char(l_stored_asg_id));
443: PAY_IE_WNU_EDI.wnu_update_extra_info
444: (p_assignment_id => asgrec.assignment_id,
445: p_effective_date => l_effective_date,