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 254: per_all_assignments_f paf

250: cursor csr_person_id is
251: select person_id,
252: paa.assignment_id
253: from pay_assignment_actions paa,
254: per_all_assignments_f paf
255: where paa.assignment_action_id = p_assact_id
256: and paa.assignment_id = paf.assignment_id;
257:
258: -- 5504855

Line 794: per_all_assignments_f paf,

790: peo.national_identifier ni_no ,
791: pai.action_information2 old_works_number
792: from pay_payroll_actions pay,
793: pay_assignment_actions paa,
794: per_all_assignments_f paf,
795: per_all_people_f peo,
796: pay_action_information pai
797: where pay.payroll_action_id = pactid
798: and paa.payroll_action_id = pay.payroll_action_id