APPS.PER_PERIODS_OF_SERVICE_PKG_V2 SQL Statements

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

Line: 38

    SELECT max(final_process_date)
    FROM per_periods_of_service
    WHERE person_id = p_person_id;

Line: 67

    SELECT *
    FROM per_periods_of_service
    WHERE period_of_service_id =
      ( SELECT max(period_of_service_id)
        FROM per_periods_of_service
        WHERE person_id = p_person_id
      );

Line: 146

    SELECT date_of_birth, business_group_id
    FROM per_people_f ppf
    WHERE ppf.person_id = p_person_id
    AND p_session_date between effective_start_date and effective_end_date;

Line: 200

    SELECT actual_termination_date
    FROM per_periods_of_service
    WHERE person_id = p_person_id
    AND final_process_date = p_final_process_date;

Line: 229

    SELECT max(date_start)
    FROM per_periods_of_service
    WHERE person_id = p_person_id
    AND final_process_date is null;

Line: 237

    SELECT max(date_start)
    FROM per_periods_of_service
    WHERE person_id = p_person_id;

Line: 278

    SELECT Min(effective_start_date) + 1
    FROM per_all_assignments_f
    WHERE person_id = p_person_id
    AND effective_start_date > p_check_date;

Line: 307

    SELECT Max(effective_start_date) + 1
    FROM per_all_assignments_f
    WHERE person_id = p_person_id
    AND effective_start_date < p_check_date;

Line: 338

    SELECT min(effective_end_date)
    FROM per_all_people_f
    WHERE person_id = p_person_id
    AND effective_end_date between p_date_from + 1 and p_date_to -1;

Line: 370

    SELECT max(effective_start_date) +1
    FROM per_all_people_f
    WHERE person_id = p_person_id
    AND effective_start_date between p_date_from + 1 and p_date_to -1;

Line: 402

    SELECT effective_start_date
    FROM per_people_f ppf, per_person_types ppt
    WHERE ppf.person_id = p_person_id
    AND ppf.person_type_id = ppt.person_type_id
    AND ppf.effective_start_date > p_current_hire_date;

Line: 450

    SELECT COUNT (*), person_type_id
    FROM per_people_f
    WHERE person_id = p_person_id
    AND effective_start_date > p_final_process_date
    GROUP BY person_type_id;

Line: 524

    SELECT min(effective_start_date) + 1
    FROM per_all_assignments_f paf
    ,    per_assignment_status_types past
    WHERE person_id = p_person_id
    AND   paf.assignment_status_type_id = past.assignment_status_type_id
    AND   past.per_system_status = 'ACCEPTED';