APPS.OTA_LP_XMLP_PKG SQL Statements

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

Line: 7

   select name
   from ota_learning_paths_tl
   where learning_path_id = P_LP_ID
   and language = userenv('LANG');

Line: 23

    select es.meaning
    from hr_lookups es
    WHERE es.lookup_type = 'OTA_LP_CURRENT_STATUS'
    AND sysdate BETWEEN NVL(es.start_date_active,sysdate) AND NVL (es.end_date_active, sysdate)
    AND es.enabled_flag ='Y'
    AND es.lookup_code = P_LP_STATUS_CODE ;

Line: 41

  SELECT ppf.full_name
  FROM per_all_people_f ppf
  WHERE trunc(sysdate) BETWEEN nvl(ppf.effective_start_date, trunc(sysdate)) AND nvl(ppf.effective_end_date, trunc(sysdate))
  AND ppf.person_id = P_LEARNER_ID;