DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PER_ASSIGNMENTS_F

Line 160: FROM per_assignments_f paf,

156: ,p_effective_date in date) IS
157: SELECT ppf.first_name, ppf.last_name, ppf.middle_names, ppf.order_name,
158: ppf.full_name, ppf.national_identifier,
159: ppf.employee_number
160: FROM per_assignments_f paf,
161: per_all_people_f ppf,
162: per_periods_of_service pps
163: WHERE paf.person_id = ppf.person_id
164: and paf.assignment_id = p_assignment_id