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.

APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_PERIODS_OF_SERVICE

Line 150: ,per_periods_of_service pps

146: FROM pay_payroll_actions ppa
147: ,per_people_f pap
148: ,per_assignments_f paa
149: ,hr_soft_coding_keyflex hsc
150: ,per_periods_of_service pps
151: ,pay_element_entries_f pee
152: ,pay_element_links_f pel
153: ,pay_element_types_f pet
154: ,pay_input_values_f piv

Line 166: from per_periods_of_service pps1

162: AND hsc.segment1 = c_legal_employer_id
163: AND pps.person_id = paa.person_id
164: And pps.period_of_service_id = paa.period_of_service_id
165: AND pps.date_start= (select max(pps1.date_start)
166: from per_periods_of_service pps1
167: where pps1.person_id=pps.person_id
168: AND pps1.date_start <= c_report_end_date
169: ) /*Bug2751008*/
170: AND paa.effective_start_date = (SELECT max(effective_Start_date)