APPS.PER_IE_TERMINATION SQL Statements

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

Line: 24

	select ppos.person_id
    	from per_periods_of_service ppos
	   where period_of_service_id = c_period_of_service_id;

Line: 31

	select paaf.assignment_id
    	from per_all_assignments_f paaf
	    where paaf.person_id = c_person_id and
              c_effective_date between effective_start_date
                                    and effective_end_date;

Line: 66

   select assignment_id
    from per_assignments_f
        where period_of_service_id = p_period_of_service_id;

Line: 75

         SELECT   paye_details_id,
                  effective_start_date,
                  effective_end_date
             FROM pay_ie_paye_details_f
            WHERE assignment_id = p_assignment_id AND
                  p_final_process_date BETWEEN effective_start_date
                                                AND effective_end_date
         ORDER BY effective_start_date;

Line: 88

         SELECT   prsi_details_id, effective_start_date, effective_end_date
             FROM pay_ie_prsi_details_f
            WHERE assignment_id = p_assignment_id AND
                  p_final_process_date BETWEEN effective_start_date
                                                AND effective_end_date
         ORDER BY effective_start_date;

Line: 136

	          UPDATE pay_ie_prsi_details_f
	             SET effective_end_date = p_final_process_date
	           WHERE prsi_details_id = l_prsi_detail_id AND
	                 p_final_process_date BETWEEN effective_start_date
	                                          AND effective_end_date;

Line: 142

	          DELETE FROM pay_ie_prsi_details_f
	                WHERE prsi_details_id = l_prsi_detail_id AND
	                      effective_start_date > p_final_process_date;

Line: 152

	          UPDATE pay_ie_paye_details_f
	             SET effective_end_date = p_final_process_date
	           WHERE paye_details_id = l_paye_detail_id AND
	                 p_final_process_date BETWEEN effective_start_date
	                                          AND effective_end_date;

Line: 157

	          DELETE FROM pay_ie_paye_details_f
	                WHERE paye_details_id = l_paye_detail_id AND
	                      effective_start_date > p_final_process_date;

Line: 185

      SELECT max(effective_end_date)
        FROM pay_ie_paye_details_f
       WHERE assignment_id = p_assignment_id;

Line: 208

          UPDATE pay_ie_paye_details_f
             SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')
           WHERE assignment_id = asg_id.assignment_id AND
                 l_final_process_date BETWEEN effective_start_date
                                          AND effective_end_date;

Line: 214

          UPDATE pay_ie_prsi_details_f
             SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')
           WHERE assignment_id = asg_id.assignment_id AND
                 l_final_process_date BETWEEN effective_start_date
                                          AND effective_end_date;