DBA Data[Home] [Help]

APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 594: ,per_periods_of_service service

590: IS
591: SELECT DISTINCT assignment.assignment_id
592: FROM per_people_f person
593: ,per_assignments_f assignment
594: ,per_periods_of_service service
595: ,pay_element_types_f element
596: ,pay_element_links_f link
597: ,pay_element_entries_f entry
598: WHERE person.person_id BETWEEN p_start_person

Line 960: per_periods_of_service service,

956: , assignment.assignment_id) periods
957: ,period_types.number_per_fiscal_year total_periods
958: FROM per_people_f person,
959: per_assignments_f assignment,
960: per_periods_of_service service,
961: pay_payrolls_f payroll,
962: per_time_period_types period_types,
963: pay_assignment_actions actions
964: WHERE person.business_group_id = c_business_group_id