APPS.OTA_CERT_XMLP_PKG SQL Statements

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

Line: 6

    select name
    from ota_certifications_tl
    where certification_id = P_CERTIFICATION_ID
    and language = userenv('LANG') ;

Line: 19

    select es.meaning
    from hr_lookups es
    WHERE es.lookup_type='OTA_CERT_ENROLL_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_SUBSCRIPTION_STATUS ;

Line: 35

     select fnd_date.date_to_displaydate(to_date(substr((P_SUBSCRIPTION_START_DATE),1,10),'yyyy/mm/dd'))
     into C_SUBSCRIPTION_START_DATE
     from dual;

Line: 43

     select fnd_date.date_to_displaydate(to_date(substr((P_SUBSCRIPTION_END_DATE),1,10),'yyyy/mm/dd'))
     into C_SUBSCRIPTION_END_DATE
     from dual;

Line: 51

     select fnd_date.date_to_displaydate(to_date(substr((P_EXPIRY_FROM_DATE),1,10),'yyyy/mm/dd'))
     into C_EXPIRY_FROM_DATE
     from dual;

Line: 59

     select fnd_date.date_to_displaydate(to_date(substr((P_EXPIRY_TO_DATE),1,10),'yyyy/mm/dd'))
     into C_EXPIRY_TO_DATE
     from dual;