DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PER_ASSIGNMENTS_F

Line 164: FROM per_assignments_f paf,

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