[Home] [Help]
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
142: WHERE per.person_id = asg.person_id
143: AND per.national_identifier = tbi.pps_number
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,
244: per_periods_of_service pps
245: WHERE per.person_id = asg.person_id
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
288: WHERE per.person_id = asg.person_id
289: AND asg.business_group_id = hou.business_group_id
310: from pay_ie_tax_body_interface;
311:
312: /* check to see if any single paye details exists */
313: cursor get_paye_details (p_assignment_id number) is
314: select count(*) from pay_ie_paye_details_f where
315: assignment_id = p_assignment_id;
316:
317: -- For Bug 5724436
318: -- Cursor to get the max assignment action id, to fetch the P45 details.
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
339: and paaf.assignment_id = ppd.assignment_id
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
401: l_header_count NUMBER := 0;
402: l_record_count NUMBER := 0;
403: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;
404: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;
402: l_record_count NUMBER := 0;
403: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;
404: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;
405:
406: l_usc_tax_basis pay_ie_paye_details_f.usc_tax_basis%TYPE;
407: --Declare output parameters from api row handlersb
408: l_ins_paye_details_id NUMBER;
409: l_ins_object_version_no NUMBER;
410: l_ins_effective_start_date DATE;
1079: -- WHEN same_day THEN
1080: -- l_error := SQLERRM;
1081: -- retcode := 1;
1082: -- FND_FILE.PUT_LINE(fnd_file.log, 'This record has already been updated today with changes to the
1083: -- PAY_IE_PAYE_DETAILS_F table');
1084: --
1085: --
1086: -- FND_FILE.NEW_LINE(fnd_file.log, 1);
1087: -- FND_FILE.PUT_LINE(fnd_file.output, r_pay.pps_number_hr ||','||
3235: COMMIT;
3236: END count_validation;
3237:
3238: -- Procedure to validate every row from the interface table and update
3239: -- PAY_IE_PAYE_DETAILS_F table if required.
3240:
3241: PROCEDURE valinsupd (
3242: errbuf OUT NOCOPY VARCHAR2
3243: , retcode OUT NOCOPY VARCHAR2
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
3331: WHERE per.person_id = asg.person_id
3332: AND per.national_identifier = tbi.pps_number
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,
3397: per_periods_of_service pps
3398: WHERE per.person_id = asg.person_id
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
3441: WHERE per.person_id = asg.person_id
3442: AND asg.business_group_id = hou.business_group_id
3463: from pay_ie_tax_body_interface;
3464:
3465: /* check to see if any single paye details exists */
3466: cursor get_paye_details (p_assignment_id number) is
3467: select count(*) from pay_ie_paye_details_f where
3468: assignment_id = p_assignment_id;
3469:
3470: -- For Bug 5724436
3471: -- Cursor to get the max assignment action id, to fetch the P45 details.
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
3492: and paaf.assignment_id = ppd.assignment_id
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
3554: l_header_count NUMBER := 0;
3555: l_record_count NUMBER := 0;
3556: l_std_rate_of_tax pay_ie_tax_body_interface.std_rate_of_tax%TYPE;
3557: l_higher_rate_of_tax pay_ie_tax_body_interface.higher_rate_of_tax%TYPE;
4070: -- WHEN same_day THEN
4071: -- l_error := SQLERRM;
4072: -- retcode := 1;
4073: -- FND_FILE.PUT_LINE(fnd_file.log, 'This record has already been updated today with changes to the
4074: -- PAY_IE_PAYE_DETAILS_F table');
4075: --
4076: --
4077: -- FND_FILE.NEW_LINE(fnd_file.log, 1);
4078: -- FND_FILE.PUT_LINE(fnd_file.output, r_pay.pps_number_hr ||','||
4663: , weekly_tax_credit
4664: , weekly_std_rate_cut_off
4665: , monthly_tax_credit
4666: , monthly_std_rate_cut_off
4667: FROM pay_ie_paye_details_f
4668: WHERE paye_details_id = p_paye_details_id;
4669:
4670: CURSOR c_lookup_meaning(p_lookup_type VARCHAR2,p_lookup_code VARCHAR2)
4671: IS