DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on PER_ALL_ASSIGNMENTS_F

Line 23: from per_all_assignments_f.

19: 19-JUN-2001 S.Robinson 115.1 Change to cursor c_state to ensure
20: assignments only selected once and
21: character validation is enforced.
22: 06-AUG-2002 A.Mills 115.2 2473608. Added join to periods_of_service
23: from per_all_assignments_f.
24: 07-AUG-2002 A.Mills 115.4 Enabled package for Aggregated PAYE.
25: 02-DEC-2002 G.Butler 115.7 nocopy qualifier added to range_cursor
26: 18-DEC-2003 asengar 115.8 BUG 3294480 Changed code for NI update
27: 08-SEP-2004 K.Thampan 115.9 Revert the change for bug 2545016

Line 259: per_all_assignments_f paf

255: cursor csr_person_id is
256: select person_id,
257: paa.assignment_id
258: from pay_assignment_actions paa,
259: per_all_assignments_f paf
260: where paa.assignment_action_id = p_assact_id
261: and paa.assignment_id = paf.assignment_id;
262:
263: -- 5504855

Line 811: per_all_assignments_f paf,

807: peo.national_identifier ni_no ,
808: pai.action_information2 old_works_number
809: from pay_payroll_actions pay,
810: pay_assignment_actions paa,
811: per_all_assignments_f paf,
812: per_all_people_f peo,
813: pay_action_information pai
814: where pay.payroll_action_id = pactid
815: and paa.payroll_action_id = pay.payroll_action_id