DBA Data[Home] [Help]

APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 179: ,per_periods_of_service ppos

175: ,c_payroll_id NUMBER
176: ) IS
177: SELECT assignment_id
178: FROM per_all_assignments_f asl
179: ,per_periods_of_service ppos
180: ,pay_payroll_actions ppa
181: WHERE ppa.payroll_action_id = c_pact_id
182: AND asl.person_id BETWEEN c_stperson AND c_endperson
183: AND asl.primary_flag = 'Y'

Line 361: ,per_periods_of_service ppf

357: ,hoi.organization_id organization_id
358: ,hoi.org_information1 company_name
359: ,paas.payroll_action_id
360: FROM per_all_people_F pap
361: ,per_periods_of_service ppf
362: ,per_all_assignments_f paa
363: ,pay_assignment_actions paas
364: ,hr_soft_coding_keyflex hr
365: ,hr_organization_information hoi