APPS.PAY_US_UPDATE_TAX_REC_PKG SQL Statements

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

Line: 13

	l_proc		VARCHAR2(100) := 'pay_us_update_tax_rec_pkg.terminate_emp_tax_records';

Line: 16

	select	min(ftr.effective_start_date)
	from	pay_us_emp_fed_tax_rules_f ftr
	where	ftr.assignment_id = p_asg_id;

Line: 22

	select	pee.element_entry_id
	from	pay_element_entries_f pee,
		pay_element_links_f pel,
		pay_element_types_f pet
	where	pee.element_link_id = pel.element_link_id
	  and	pel.element_type_id = pet.element_type_id
	  and	p_ef_date between pet.effective_start_date and pet.effective_end_date
	  and	p_ef_date between pel.effective_start_date and pel.effective_end_date
	  and	p_ef_date between pee.effective_start_date and pee.effective_end_date
	  and	(pet.element_name like '%VERTEX%'
	         or upper(pet.element_name) = 'WORKERS COMPENSATION')
	  and	pee.assignment_id = p_asg_id;

Line: 69

             UPDATE  pay_us_emp_fed_tax_rules_f peft
             SET     peft.effective_end_date    = l_new_end_date
             WHERE   peft.assignment_id         = p_assignment_id
             AND     l_ef_date
             BETWEEN peft.effective_start_date AND peft.effective_end_date;

Line: 75

	     DELETE pay_us_emp_fed_tax_rules_f peft
	     WHERE  peft.assignment_id 		= p_assignment_id
	     AND    peft.effective_start_date 	> l_ef_date;

Line: 80

             UPDATE  pay_us_emp_state_tax_rules_f pest
             SET     pest.effective_end_date    =  l_new_end_date
             WHERE   pest.assignment_id         =  p_assignment_id
             AND     l_ef_date
             BETWEEN pest.effective_start_date AND pest.effective_end_date;

Line: 86

	     DELETE pay_us_emp_state_tax_rules_f pest
	     WHERE  pest.assignment_id 		= p_assignment_id
	     AND    pest.effective_start_date 	> l_ef_date;

Line: 91

             UPDATE  pay_us_emp_county_tax_rules_f pect
             SET     pect.effective_end_date    =  l_new_end_date
             WHERE   pect.assignment_id         = p_assignment_id
             AND     l_ef_date
             BETWEEN pect.effective_start_date  AND pect.effective_end_date;

Line: 97

	     DELETE pay_us_emp_county_tax_rules_f pect
	     WHERE  pect.assignment_id 		= p_assignment_id
	     AND    pect.effective_start_date 	> l_ef_date;

Line: 102

             UPDATE  pay_us_emp_city_tax_rules_f pecit
             SET     pecit.effective_end_date   =  l_new_end_date
             WHERE   pecit.assignment_id        =  p_assignment_id
             AND     l_ef_date
             BETWEEN pecit.effective_start_date AND pecit.effective_end_date;

Line: 108

	     DELETE pay_us_emp_city_tax_rules_f pecit
	     WHERE  pecit.assignment_id 	= p_assignment_id
	     AND    pecit.effective_start_date 	> l_ef_date;

Line: 124

	   -- else we want to delete any changes after the ATD

	   if l_default_date > l_ef_date then
		l_ef_date := l_default_date;

Line: 137

		hr_entry_api.delete_element_entry(
 		 p_dt_delete_mode  	=> l_dt_mode,
  		 p_session_date		=> l_ef_date,
  		 p_element_entry_id    	=> c_ele_rec.element_entry_id
 		);

Line: 167

	('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',5);

Line: 168

        UPDATE  pay_us_emp_fed_tax_rules_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: 175

	('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',6);

Line: 176

        UPDATE  pay_us_emp_state_tax_rules_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;

Line: 183

	('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',7);

Line: 184

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

Line: 191

	('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',8);

Line: 192

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