DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on PER_ALL_PEOPLE_F

Line 126: from per_all_people_f pap,

122: select /*+ ORDERED */
123: asg.assignment_id assignment_id,
124: decode(pap.per_information10,'Y','Y',NULL) agg_paye_flag,
125: pap.person_id
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,

Line 273: from per_all_people_f pap,

269:
270: cursor asg_act is
271: select /*+ ORDERED */
272: asg.assignment_id assignment_id
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,

Line 812: per_all_people_f peo,

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