APPS.PAY_GB_WNU_EDI dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 34: per_assignment_extra_info table. This is

30: NI number.
31: 25-MAY-2005 K.Thampan 115.11 Bug 4392220 - Amended the cursor c_state in
32: procedure wnu_cleanse_act_creation to return
33: assignments that does't have a record on the
34: per_assignment_extra_info table. This is
35: because these assignments might have been entered
36: using API, instead of front end (Form).
37: 09-FEB-2006 K.Thampan 115.12 Fixed bug 4938724. Set g_stored_asg_id to null
38: 16-JUN-2006 K.Thampan 115.13 Code change for EDI Rollback.

Line 130: per_assignment_extra_info aei,

126: from per_all_people_f pap,
127: per_assignments_f asg,
128: per_periods_of_service serv,
129: pay_all_payrolls_f pay,
130: per_assignment_extra_info aei,
131: hr_soft_coding_keyflex sck
132: where pap.person_id between stperson and endperson
133: and asg.business_group_id = l_business_group_id
134: and asg.person_id = pap.person_id

Line 266: from per_assignment_extra_info aei

262:
263: -- 5504855
264: cursor csr_wnu(p_asg_id number) is
265: select aei.assignment_extra_info_id
266: from per_assignment_extra_info aei
267: where aei.assignment_id = p_asg_id
268: and aei.information_type = 'GB_WNU';
269:
270: cursor asg_act is

Line 277: per_assignment_extra_info aei,

273: from per_all_people_f pap,
274: per_assignments_f asg,
275: per_periods_of_service serv,
276: pay_all_payrolls_f pay,
277: per_assignment_extra_info aei,
278: hr_soft_coding_keyflex sck
279: where pap.person_id = l_person_id
280: and asg.business_group_id = l_business_group_id
281: and asg.person_id = pap.person_id

Line 408: per_assignment_extra_info aei

404: aei.aei_information3 ni_update,
405: aei.object_version_number,
406: paa.assignment_id
407: from pay_assignment_actions paa,
408: per_assignment_extra_info aei
409: where paa.assignment_action_id = p_assactid
410: and paa.assignment_id = aei.assignment_id
411: and aei.information_type = 'GB_WNU';
412: