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_PEOPLE_F

Line 290: per_all_people_f per,

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
294: where per.national_identifier = tbi.pps_number

Line 312: Select 1 from per_all_people_f per

308: --AND pay.effective_end_date >= trunc(tbi.cert_start_date)
309: group by per.person_id,per.NATIONAL_IDENTIFIER;
310:
311: /* Cursor check_pps(p_pps_no varchar) is
312: Select 1 from per_all_people_f per
313: ,pay_ie_tax_body_interface tbi
314: Where per.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
315: AND per.effective_end_date >= trunc(tbi.cert_start_date)
316: and per.national_identifier=p_pps_no

Line 358: , per_all_people_f per

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
362: , pay_ie_tax_header_interface thi

Line 424: , per_all_people_f per

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
428: , pay_ie_tax_header_interface thi,

Line 468: , per_all_people_f per

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
472: , pay_ie_tax_header_interface thi

Line 518: from per_all_people_f papf,

514: ,p_ppsn varchar2
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

Line 573: l_employee_number_hr per_all_people_F.employee_number%TYPE; -- bug 5766372

569: l_program_application_id NUMBER;
570: l_program_id NUMBER;
571: l_comm_period_no NUMBER;
572: l_pps_number_hr VARCHAR2(9);
573: l_employee_number_hr per_all_people_F.employee_number%TYPE; -- bug 5766372
574: l_last_name_hr per_people_f.last_name%TYPE;
575: l_first_name_hr per_people_f.first_name%TYPE;
576: l_last_name_int VARCHAR2(20);
577: l_first_name_int VARCHAR2(20);