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 33: per_all_people_f per,

29: select per.person_id person_id
30: ,per.NATIONAL_IDENTIFIER pps_number
31: ,count(distinct(asg.ASSIGNMENT_NUMBER)) no_of_assg
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

Line 55: Select 1 from per_all_people_f per

51: --AND pay.effective_end_date >= trunc(tbi.cert_start_date)
52: group by per.person_id,per.NATIONAL_IDENTIFIER;
53:
54: /* Cursor check_pps(p_pps_no varchar) is
55: Select 1 from per_all_people_f per
56: ,pay_ie_tax_body_interface tbi
57: Where per.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
58: AND per.effective_end_date >= trunc(tbi.cert_start_date)
59: and per.national_identifier=p_pps_no

Line 137: , per_all_people_f per

133: --13359423
134: FROM hr_organization_information hoi
135: , hr_organization_units hou
136: , per_all_assignments_f asg
137: , per_all_people_f per
138: , pay_all_payrolls_f pay
139: --, pay_ie_paye_details_f ppd
140: , pay_ie_tax_body_interface tbi
141: , pay_ie_tax_header_interface thi

Line 239: , per_all_people_f per

235: --13359423
236: FROM hr_organization_information hoi
237: , hr_organization_units hou
238: , per_all_assignments_f asg
239: , per_all_people_f per
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,

Line 283: , per_all_people_f per

279: SELECT distinct per.national_identifier pps_number, asg.assignment_number works_number
280: FROM hr_organization_information hoi
281: , hr_organization_units hou
282: , per_all_assignments_f asg
283: , per_all_people_f per
284: , pay_all_payrolls_f pay
285: --, pay_ie_paye_details_f ppd
286: , pay_ie_tax_body_interface tbi
287: , pay_ie_tax_header_interface thi

Line 333: from per_all_people_f papf,

329: ,p_ppsn varchar2
330: ,p_cert_start_date date
331: ,p_assignment_number varchar2) is
332: select distinct ppd.*
333: from per_all_people_f papf,
334: per_all_assignments_f paaf,
335: pay_ie_paye_details_f ppd
336: where papf.national_identifier = p_ppsn
337: and papf.person_id = paaf.person_id

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

384: l_program_application_id NUMBER;
385: l_program_id NUMBER;
386: l_comm_period_no NUMBER;
387: l_pps_number_hr VARCHAR2(9);
388: l_employee_number_hr per_all_people_F.employee_number%TYPE; -- bug 5766372
389: l_last_name_hr per_people_f.last_name%TYPE;
390: l_first_name_hr per_people_f.first_name%TYPE;
391: l_last_name_int VARCHAR2(20);
392: l_first_name_int VARCHAR2(20);

Line 3258: per_all_people_f per,

3254: select per.person_id person_id
3255: ,per.NATIONAL_IDENTIFIER pps_number
3256: ,count(distinct(asg.ASSIGNMENT_NUMBER)) no_of_assg
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

Line 3280: Select 1 from per_all_people_f per

3276: --AND pay.effective_end_date >= trunc(tbi.cert_start_date)
3277: group by per.person_id,per.NATIONAL_IDENTIFIER;
3278:
3279: /* Cursor check_pps(p_pps_no varchar) is
3280: Select 1 from per_all_people_f per
3281: ,pay_ie_tax_body_interface tbi
3282: Where per.effective_start_date <= to_date('31/12/'||to_char(tbi.cert_start_date,'YYYY'),'dd/mm/yyyy')
3283: AND per.effective_end_date >= trunc(tbi.cert_start_date)
3284: and per.national_identifier=p_pps_no

Line 3326: , per_all_people_f per

3322: , tbi.higher_rate_of_tax higher_rate_of_tax
3323: FROM hr_organization_information hoi
3324: , hr_organization_units hou
3325: , per_all_assignments_f asg
3326: , per_all_people_f per
3327: , pay_all_payrolls_f pay
3328: --, pay_ie_paye_details_f ppd
3329: , pay_ie_tax_body_interface tbi
3330: , pay_ie_tax_header_interface thi

Line 3392: , per_all_people_f per

3388: , tbi.higher_rate_of_tax higher_rate_of_tax
3389: FROM hr_organization_information hoi
3390: , hr_organization_units hou
3391: , per_all_assignments_f asg
3392: , per_all_people_f per
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,

Line 3436: , per_all_people_f per

3432: SELECT distinct per.national_identifier pps_number, asg.assignment_number works_number
3433: FROM hr_organization_information hoi
3434: , hr_organization_units hou
3435: , per_all_assignments_f asg
3436: , per_all_people_f per
3437: , pay_all_payrolls_f pay
3438: --, pay_ie_paye_details_f ppd
3439: , pay_ie_tax_body_interface tbi
3440: , pay_ie_tax_header_interface thi

Line 3486: from per_all_people_f papf,

3482: ,p_ppsn varchar2
3483: ,p_cert_start_date date
3484: ,p_assignment_number varchar2) is
3485: select distinct ppd.*
3486: from per_all_people_f papf,
3487: per_all_assignments_f paaf,
3488: pay_ie_paye_details_f ppd
3489: where papf.national_identifier = p_ppsn
3490: and papf.person_id = paaf.person_id

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

3537: l_program_application_id NUMBER;
3538: l_program_id NUMBER;
3539: l_comm_period_no NUMBER;
3540: l_pps_number_hr VARCHAR2(9);
3541: l_employee_number_hr per_all_people_F.employee_number%TYPE; -- bug 5766372
3542: l_last_name_hr per_people_f.last_name%TYPE;
3543: l_first_name_hr per_people_f.first_name%TYPE;
3544: l_last_name_int VARCHAR2(20);
3545: l_first_name_int VARCHAR2(20);