DBA Data[Home] [Help]

APPS.PAY_IE_TAX_VAL dependencies on HR_ORGANIZATION_INFORMATION

Line 355: FROM hr_organization_information hoi

351: , tbi.tot_tax_to_date/100 tot_tax_to_date
352: , tbi.tot_pay_to_date/100 tot_pay_to_date
353: , tbi.std_rate_of_tax std_rate_of_tax
354: , tbi.higher_rate_of_tax higher_rate_of_tax
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

Line 421: FROM hr_organization_information hoi

417: , tbi.tot_tax_to_date/100 tot_tax_to_date
418: , tbi.tot_pay_to_date/100 tot_pay_to_date
419: , tbi.std_rate_of_tax std_rate_of_tax
420: , tbi.higher_rate_of_tax higher_rate_of_tax
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

Line 465: FROM hr_organization_information hoi

461: /* cursor csr_skipped_asg is
462: select pps_number, works_number from pay_ie_tax_body_interface
463: minus
464: SELECT distinct per.national_identifier pps_number, asg.assignment_number works_number
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