APPS.HR_CANCEL_PLACEMENT_API SQL Statements

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

Line: 35

    SELECT date_start,
           business_group_id
    FROM   per_periods_of_placement pp
    WHERE  pp.person_id = p_person_id
    AND    l_effective_date BETWEEN pp.date_start
                                AND NVL(pp.actual_termination_date,hr_general.end_of_time);