eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 975: per_periods_of_service service,

971: , assignment.assignment_id) periods
972: ,period_types.number_per_fiscal_year total_periods
973: FROM per_people_f person,
974: per_assignments_f assignment,
975: per_periods_of_service service,
976: pay_payrolls_f payroll,
977: per_time_period_types period_types,
978: pay_assignment_actions actions
979: WHERE person.business_group_id = c_business_group_id