APPS.PER_IN_PERSON_TERM_LEG_HOOK SQL Statements

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

Line: 139

  pay_in_termination_pkg.delete_termination_elements
             (p_period_of_service_id    => p_period_of_service_id
             ,p_business_group_id       => p_business_group_id
             ,p_actual_termination_date => p_actual_termination_date
	     ,p_calling_procedure       => p_calling_procedure
	     ,p_message_name            => p_message_name
             ,p_token_name              => p_token_name
             ,p_token_value             => p_token_value);

Line: 193

   SELECT final_process_date
         ,actual_termination_date
     FROM per_periods_of_service
    WHERE period_of_service_id = p_period_of_service_id;

Line: 274

     SELECT pos.business_group_id
           ,pos.actual_termination_date
     FROM   per_periods_of_service pos
     WHERE  pos.period_of_service_id = p_period_of_service_id;

Line: 448

PROCEDURE update_pds_details
                (p_period_of_service_id       IN NUMBER
                ,p_effective_date             IN DATE
                ,p_leaving_reason             IN VARCHAR2
                 )
IS
  CURSOR c_pos_dtls IS
     SELECT pos.actual_termination_date
           ,ppf.business_group_id
     FROM   per_periods_of_service pos
	   ,per_assignments_f paf
	   ,per_people_f ppf
     WHERE  pos.period_of_service_id = p_period_of_service_id
     AND    pos.period_of_service_id = paf.period_of_service_id
     AND    paf.person_id            = ppf.person_id
     AND    p_effective_date  BETWEEN ppf.effective_start_date
                              AND     ppf.effective_end_date
     AND    p_effective_date  BETWEEN paf.effective_start_date
                              AND     paf.effective_end_date;

Line: 476

  l_procedure := g_package || 'update_pds_details' ;

Line: 510

     pay_in_termination_pkg.delete_gratuity_entry
              (p_period_of_service_id    => p_period_of_service_id
              ,p_business_group_id       => l_business_group_id
              ,p_actual_termination_date => l_actual_termination_date
              ,p_calling_procedure       => l_procedure
              ,p_message_name            => g_message_name
              ,p_token_name              => g_token_name
              ,p_token_value             => g_token_value
              );

Line: 556

END update_pds_details;