DBA Data[Home] [Help]

APPS.PAY_IE_WNU_EDI dependencies on PER_ALL_PEOPLE_F

Line 27: from per_all_people_f apf,

23: l_ovn number(15);
24: --
25: cursor csr_employee is
26: select upper(apf.current_employee_flag)
27: from per_all_people_f apf,
28: per_all_assignments_f aaf
29: where aaf.person_id = apf.person_id
30: and aaf.assignment_id = p_assignment_id
31: and p_effective_date between

Line 164: per_all_people_f pap,

160: select asg.assignment_id assignment_id,
161: ppa.effective_date effective_date
162: from per_all_assignments_f asg,
163: pay_payroll_actions ppa,
164: per_all_people_f pap,
165: per_periods_of_service serv,
166: -- hr_organization_information hoi,
167: pay_all_payrolls_f pay,
168: hr_soft_coding_keyflex sck

Line 323: per_all_people_f pap,

319: select asg.assignment_id assignment_id,
320: ppa.effective_date effective_date
321: from per_all_assignments_f asg,
322: pay_payroll_actions ppa,
323: per_all_people_f pap,
324: per_periods_of_service serv,
325: per_assignment_extra_info aei,
326: -- hr_organization_information hoi,
327: pay_all_payrolls_f pay,