APPS.GHR_VALIDATE_PERWSEPI SQL Statements

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

Line: 16

    SELECT ppf.person_id
    FROM per_people_f ppf, per_person_types pty
    WHERE  ppf.person_id = p_person_id
    AND    p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
    AND    ppf.person_type_id = pty.person_type_id
    AND    pty.system_person_type = 'EMP'
    AND    pty.business_group_id = p_business_group_id
    AND    pty.active_flag = 'Y';

Line: 44

  SELECT 'Request Number:'||par.request_number||
        ', 1st NOA Code:'||par.first_noa_code||
        DECODE(par.second_noa_code,NULL,NULL, ', 2nd NOA Code:'||par.second_noa_code)||
        ', Effective Date:'||par.effective_date||
        ', Updater:'||prh.user_name     list_info
  FROM   ghr_pa_routing_history prh
        ,ghr_pa_requests        par
  WHERE  par.person_id = p_person_id
  AND    par.effective_date BETWEEN NVL(p_from_date,par.effective_date) AND NVL(p_to_date,par.effective_date)
  AND    prh.pa_request_id  = par.pa_request_id
  AND    prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)
                                      FROM   ghr_pa_routing_history prh2
                                      WHERE  prh2.pa_request_id = par.pa_request_id)
  AND    prh.action_taken IN ('FUTURE_ACTION')
  ORDER BY par.effective_date, par.pa_request_id;