APPS.PER_GB_TERMINATION SQL Statements

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

Line: 25

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

Line: 68

      SELECT date_of_birth
        FROM per_all_people_f
       WHERE person_id = p_person_id
         AND p_actual_termination_date between effective_start_date and effective_end_date;

Line: 76

       SELECT assignment_id, assignment_number
         FROM per_all_assignments_f asg,
              per_assignment_status_types typ
        WHERE asg.person_id = p_person_id
          AND asg.period_of_service_id = p_period_of_service_id
          AND asg.assignment_status_type_id = typ.assignment_status_type_id
          AND typ.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
          AND p_date_active between asg.effective_start_date and asg.effective_end_date
       ORDER BY assignment_id;