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 148: ,per_periods_of_service pps

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

Line 163: from per_periods_of_service pps1

159: AND paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
160: AND hsc.segment1 = c_legal_employer_id
161: AND pps.person_id = paa.person_id
162: AND pps.date_start= (select max(pps1.date_start)
163: from per_periods_of_service pps1
164: where pps1.person_id=pps.person_id
165: AND pps1.date_start <= c_report_end_date
166: ) /*Bug2751008*/
167: AND paa.effective_start_date = (SELECT max(effective_Start_date)