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 32: from per_all_assignments_f asg,

28: cursor c_no_of_assg IS
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

Line 136: , per_all_assignments_f asg

132: ,tbi.cd_usc_rate_5
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

Line 238: , per_all_assignments_f asg

234: ,tbi.cd_usc_rate_5
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

Line 282: , per_all_assignments_f asg

278: minus
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

Line 334: per_all_assignments_f paaf,

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
338: and paaf.assignment_id = p_assignment_id

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

392: l_first_name_int VARCHAR2(20);
393: l_payroll_name_hr VARCHAR2(80);
394: l_tax_district NUMBER;
395: l_pps_number_int VARCHAR2(9);
396: l_employee_number_int per_all_assignments_f.assignment_number%TYPE; -- bug 5766372
397: l_validate BOOLEAN := FALSE;
398: -- Bug Fix 3500192
399: l_datetrack_mode VARCHAR2(12);
400: l_tax_basis pay_ie_paye_details_f.tax_basis%TYPE; -- bug 5766372

Line 3257: from per_all_assignments_f asg,

3253: cursor c_no_of_assg IS
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

Line 3325: , per_all_assignments_f asg

3321: , tbi.std_rate_of_tax std_rate_of_tax
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

Line 3391: , per_all_assignments_f asg

3387: , tbi.std_rate_of_tax std_rate_of_tax
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

Line 3435: , per_all_assignments_f asg

3431: minus
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

Line 3487: per_all_assignments_f paaf,

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
3491: and paaf.assignment_id = p_assignment_id

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

3545: l_first_name_int VARCHAR2(20);
3546: l_payroll_name_hr VARCHAR2(80);
3547: l_tax_district NUMBER;
3548: l_pps_number_int VARCHAR2(9);
3549: l_employee_number_int per_all_assignments_f.assignment_number%TYPE; -- bug 5766372
3550: l_validate BOOLEAN := FALSE;
3551: -- Bug Fix 3500192
3552: l_datetrack_mode VARCHAR2(12);
3553: l_tax_basis pay_ie_paye_details_f.tax_basis%TYPE; -- bug 5766372