APPS.AR_CLE_STUB_PKG SQL Statements

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

Line: 53

     select default_country into lv_def_country from AR_SYSTEM_PARAMETERS;

Line: 55

     SELECT count(*) INTO ln_count
     FROM   ar_lookups
     WHERE  lookup_type = 'AR_EMEA_COUNTRIES'
     AND    lookup_code = lv_def_country
     AND    enabled_flag = 'Y'
     AND    SYSDATE BETWEEN start_date_active AND NVL(end_date_active,SYSDATE);