APPS.PAY_CA_UPDATE_TAX_REC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

	('pay_ca_update_tax_rec_pkg.reverse_term_emp_tax_records',5);

Line: 42

        UPDATE  pay_ca_emp_fed_tax_info_f peft
        SET     peft.effective_end_date    =
                to_date('31/12/4712','DD/MM/YYYY')
        WHERE   peft.assignment_id         = p_assignment_id
        AND     peft.effective_end_date    = p_process_date;

Line: 49

	('pay_ca_update_tax_rec_pkg.reverse_term_emp_tax_records',6);

Line: 50

        UPDATE  pay_ca_emp_prov_tax_info_f pest
        SET     pest.effective_end_date    =
                to_date('31/12/4712','DD/MM/YYYY')
        WHERE   pest.assignment_id         = p_assignment_id
        AND     pest.effective_end_date    = p_process_date;