[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_lines_inserted number := 0;
if mod(l_lines_inserted,20) = 0 then
commit;
l_lines_inserted := l_lines_inserted + 1;
INSERT INTO pay_gb_tax_code_interface(
date_of_message,
effective_date,
issue_date,
form_type,
district_number,
employer_reference,
national_insurance_number,
tot_pay_prev_emp,
tot_tax_prev_emp,
tax_code,
non_cumulative_flag,
employee_name,
works_number,
processed_flag,
request_id)
VALUES (
fnd_date.canonical_to_date(date_of_message_p),
fnd_date.canonical_to_date(effective_date_p),
fnd_date.canonical_to_date(issue_date_p),
form_type_p,
to_number(district_number_p),
employer_reference_p,
ni_number_p,
total_pay_prev_emp_p,
total_tax_prev_emp_p,
tax_code_p,
week1_month1_indicator_p,
employee_name_p,
works_number_p,
'',
request_id_p);