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_IE_TAX_VAL dependencies on PER_PERIODS_OF_SERVICE

Line 293: per_periods_of_service pps

289: from per_all_assignments_f asg,
290: per_all_people_f per,
291: pay_all_payrolls_f pay,
292: pay_ie_tax_body_interface tbi,
293: per_periods_of_service pps
294: where per.national_identifier = tbi.pps_number
295: --AND pay.payroll_id = nvl(p_payroll_id,pay.payroll_id)
296: --AND asg.payroll_id = pay.payroll_id
297: AND per.person_id = asg.person_id

Line 306: and pps.period_of_service_id in (select max(pps1.period_of_service_id) from per_periods_of_service pps1 where pps1.person_id=pps.person_id and pps1.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy'))

302: AND per.effective_end_date >= trunc(tbi.cert_start_date)
303: and asg.period_of_service_id=pps.period_of_service_id
304: and pps.person_id=per.person_id
305: --and pps.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
306: and pps.period_of_service_id in (select max(pps1.period_of_service_id) from per_periods_of_service pps1 where pps1.person_id=pps.person_id and pps1.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy'))
307: --AND pay.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
308: --AND pay.effective_end_date >= trunc(tbi.cert_start_date)
309: group by per.person_id,per.NATIONAL_IDENTIFIER;
310:

Line 429: per_periods_of_service pps

425: , pay_all_payrolls_f pay
426: --, pay_ie_paye_details_f ppd
427: , pay_ie_tax_body_interface tbi
428: , pay_ie_tax_header_interface thi,
429: per_periods_of_service pps
430: WHERE per.person_id = asg.person_id
431: AND per.national_identifier = tbi.pps_number
432: AND asg.business_group_id = hou.business_group_id
433: AND hou.organization_id = hoi.organization_id

Line 450: and pps.period_of_service_id in (select max(pps1.period_of_service_id) from per_periods_of_service pps1 where pps1.person_id=pps.person_id and pps1.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy'))

446: AND tbi.process_flag = 'Y'
447: and asg.period_of_service_id=pps.period_of_service_id
448: and pps.person_id=per.person_id
449: --and pps.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
450: and pps.period_of_service_id in (select max(pps1.period_of_service_id) from per_periods_of_service pps1 where pps1.person_id=pps.person_id and pps1.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy'))
451: AND asg.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
452: AND asg.effective_end_date >= trunc(tbi.cert_start_date)
453: AND per.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
454: AND per.effective_end_date >= trunc(tbi.cert_start_date)