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

Line 36: per_periods_of_service pps

32: from per_all_assignments_f asg,
33: per_all_people_f per,
34: pay_all_payrolls_f pay,
35: pay_ie_tax_body_interface tbi,
36: per_periods_of_service pps
37: where per.national_identifier = tbi.pps_number
38: --AND pay.payroll_id = nvl(p_payroll_id,pay.payroll_id)
39: --AND asg.payroll_id = pay.payroll_id
40: AND per.person_id = asg.person_id

Line 49: 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'))

45: AND per.effective_end_date >= trunc(tbi.cert_start_date)
46: and asg.period_of_service_id=pps.period_of_service_id
47: and pps.person_id=per.person_id
48: --and pps.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
49: 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'))
50: --AND pay.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
51: --AND pay.effective_end_date >= trunc(tbi.cert_start_date)
52: group by per.person_id,per.NATIONAL_IDENTIFIER;
53:

Line 244: per_periods_of_service pps

240: , pay_all_payrolls_f pay
241: --, pay_ie_paye_details_f ppd
242: , pay_ie_tax_body_interface tbi
243: , pay_ie_tax_header_interface thi,
244: per_periods_of_service pps
245: WHERE per.person_id = asg.person_id
246: AND per.national_identifier = tbi.pps_number
247: AND asg.business_group_id = hou.business_group_id
248: AND hou.organization_id = hoi.organization_id

Line 265: 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'))

261: AND tbi.process_flag = 'Y'
262: and asg.period_of_service_id=pps.period_of_service_id
263: and pps.person_id=per.person_id
264: --and pps.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
265: 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'))
266: AND asg.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
267: AND asg.effective_end_date >= trunc(tbi.cert_start_date)
268: AND per.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
269: AND per.effective_end_date >= trunc(tbi.cert_start_date)

Line 3261: per_periods_of_service pps

3257: from per_all_assignments_f asg,
3258: per_all_people_f per,
3259: pay_all_payrolls_f pay,
3260: pay_ie_tax_body_interface tbi,
3261: per_periods_of_service pps
3262: where per.national_identifier = tbi.pps_number
3263: --AND pay.payroll_id = nvl(p_payroll_id,pay.payroll_id)
3264: --AND asg.payroll_id = pay.payroll_id
3265: AND per.person_id = asg.person_id

Line 3274: 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'))

3270: AND per.effective_end_date >= trunc(tbi.cert_start_date)
3271: and asg.period_of_service_id=pps.period_of_service_id
3272: and pps.person_id=per.person_id
3273: --and pps.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
3274: 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'))
3275: --AND pay.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
3276: --AND pay.effective_end_date >= trunc(tbi.cert_start_date)
3277: group by per.person_id,per.NATIONAL_IDENTIFIER;
3278:

Line 3397: per_periods_of_service pps

3393: , pay_all_payrolls_f pay
3394: --, pay_ie_paye_details_f ppd
3395: , pay_ie_tax_body_interface tbi
3396: , pay_ie_tax_header_interface thi,
3397: per_periods_of_service pps
3398: WHERE per.person_id = asg.person_id
3399: AND per.national_identifier = tbi.pps_number
3400: AND asg.business_group_id = hou.business_group_id
3401: AND hou.organization_id = hoi.organization_id

Line 3418: 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'))

3414: AND tbi.process_flag = 'Y'
3415: and asg.period_of_service_id=pps.period_of_service_id
3416: and pps.person_id=per.person_id
3417: --and pps.date_start <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
3418: 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'))
3419: AND asg.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
3420: AND asg.effective_end_date >= trunc(tbi.cert_start_date)
3421: AND per.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
3422: AND per.effective_end_date >= trunc(tbi.cert_start_date)