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 125: per_assignment_extra_info aei,

121: from per_all_people_f pap,
122: per_assignments_f asg,
123: per_periods_of_service serv,
124: pay_all_payrolls_f pay,
125: per_assignment_extra_info aei,
126: hr_soft_coding_keyflex sck
127: where pap.person_id between stperson and endperson
128: and asg.business_group_id = l_business_group_id
129: and asg.person_id = pap.person_id

Line 261: from per_assignment_extra_info aei

257:
258: -- 5504855
259: cursor csr_wnu(p_asg_id number) is
260: select aei.assignment_extra_info_id
261: from per_assignment_extra_info aei
262: where aei.assignment_id = p_asg_id
263: and aei.information_type = 'GB_WNU';
264:
265: cursor asg_act is

Line 272: per_assignment_extra_info aei,

268: from per_all_people_f pap,
269: per_assignments_f asg,
270: per_periods_of_service serv,
271: pay_all_payrolls_f pay,
272: per_assignment_extra_info aei,
273: hr_soft_coding_keyflex sck
274: where pap.person_id = l_person_id
275: and asg.business_group_id = l_business_group_id
276: and asg.person_id = pap.person_id

Line 403: per_assignment_extra_info aei

399: aei.aei_information3 ni_update,
400: aei.object_version_number,
401: paa.assignment_id
402: from pay_assignment_actions paa,
403: per_assignment_extra_info aei
404: where paa.assignment_action_id = p_assactid
405: and paa.assignment_id = aei.assignment_id
406: and aei.information_type = 'GB_WNU';
407: