DBA Data[Home] [Help]

APPS.PAY_IE_TAX_VAL dependencies on PAY_ALL_PAYROLLS_F

Line 291: pay_all_payrolls_f pay,

287: ,per.NATIONAL_IDENTIFIER pps_number
288: ,count(distinct(asg.ASSIGNMENT_NUMBER)) no_of_assg
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)

Line 359: , pay_all_payrolls_f pay

355: FROM hr_organization_information hoi
356: , hr_organization_units hou
357: , per_all_assignments_f asg
358: , per_all_people_f per
359: , pay_all_payrolls_f pay
360: --, pay_ie_paye_details_f ppd
361: , pay_ie_tax_body_interface tbi
362: , pay_ie_tax_header_interface thi
363: WHERE per.person_id = asg.person_id

Line 425: , pay_all_payrolls_f pay

421: FROM hr_organization_information hoi
422: , hr_organization_units hou
423: , per_all_assignments_f asg
424: , per_all_people_f per
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

Line 469: , pay_all_payrolls_f pay

465: FROM hr_organization_information hoi
466: , hr_organization_units hou
467: , per_all_assignments_f asg
468: , per_all_people_f per
469: , pay_all_payrolls_f pay
470: --, pay_ie_paye_details_f ppd
471: , pay_ie_tax_body_interface tbi
472: , pay_ie_tax_header_interface thi
473: WHERE per.person_id = asg.person_id