DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on PER_ALL_PEOPLE_F

Line 121: from per_all_people_f pap,

117: select /*+ ORDERED */
118: asg.assignment_id assignment_id,
119: decode(pap.per_information10,'Y','Y',NULL) agg_paye_flag,
120: pap.person_id
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,

Line 268: from per_all_people_f pap,

264:
265: cursor asg_act is
266: select /*+ ORDERED */
267: asg.assignment_id assignment_id
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,

Line 795: per_all_people_f peo,

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
799: and paa.action_status = p_type