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_ALL_ASSIGNMENTS_F

Line 289: from per_all_assignments_f asg,

285: cursor c_no_of_assg IS
286: select per.person_id person_id
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

Line 357: , per_all_assignments_f asg

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
360: --, pay_ie_paye_details_f ppd
361: , pay_ie_tax_body_interface tbi

Line 423: , per_all_assignments_f asg

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
426: --, pay_ie_paye_details_f ppd
427: , pay_ie_tax_body_interface tbi

Line 467: , per_all_assignments_f asg

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
470: --, pay_ie_paye_details_f ppd
471: , pay_ie_tax_body_interface tbi

Line 519: per_all_assignments_f paaf,

515: ,p_cert_start_date date
516: ,p_assignment_number varchar2) is
517: select distinct ppd.*
518: from per_all_people_f papf,
519: per_all_assignments_f paaf,
520: pay_ie_paye_details_f ppd
521: where papf.national_identifier = p_ppsn
522: and papf.person_id = paaf.person_id
523: and paaf.assignment_id = p_assignment_id

Line 581: l_employee_number_int per_all_assignments_f.assignment_number%TYPE; -- bug 5766372

577: l_first_name_int VARCHAR2(20);
578: l_payroll_name_hr VARCHAR2(80);
579: l_tax_district NUMBER;
580: l_pps_number_int VARCHAR2(9);
581: l_employee_number_int per_all_assignments_f.assignment_number%TYPE; -- bug 5766372
582: l_validate BOOLEAN := FALSE;
583: -- Bug Fix 3500192
584: l_datetrack_mode VARCHAR2(12);
585: l_tax_basis pay_ie_paye_details_f.tax_basis%TYPE; -- bug 5766372