APPS.PER_US_DEL_TAX_LEG_HOOK SQL Statements

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

Line: 4

 PROCEDURE DELETE_US_TAX_INFO
         (P_PERSON_ID in NUMBER
         ,P_EFFECTIVE_DATE in DATE
        )
IS
  --
  cursor csr_assignment_id(p_person_id NUMBER,p_effective_date DATE)
  is
	select assignment_id
	from per_all_assignments_f PAA,per_periods_of_service PPS
        where PAA.person_id=p_person_id
	and PAA.period_of_service_id=PPS.period_of_service_id
        and p_effective_date between PPS.date_start and
	nvl(PPS.actual_termination_date,to_date('4712/12/31', 'YYYY/MM/DD'));

Line: 25

hr_utility.set_location('Entering: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 10);

Line: 35

         ,p_delete_routine => 'ASSIGNMENT' );

Line: 39

  hr_utility.trace('Deleted the tax records of '||l_assignment_id);

Line: 44

hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 20);

Line: 49

   hr_utility.trace('Exception raised in PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO');

Line: 50

   hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 30);

Line: 55

END DELETE_US_TAX_INFO;