APPS.AST_UWQ_LEADS_ENUMS_PVT SQL Statements

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

Line: 25

    Select meaning
    from ast_lookups
    where lookup_type = c_lookup_type
    and lookup_code = c_lookup_code;

Line: 32

    SELECT status_code, meaning
    FROM
      as_statuses_vl
    WHERE
      enabled_flag = 'Y' and LEAD_FLAG = 'Y' and OPP_OPEN_STATUS_FLAG = 'Y'
    ORDER BY 1;

Line: 42

     select status_code,meaning
     from as_statuses_vl
     where enabled_flag = 'Y'
     and lead_flag = 'Y'
     and opp_open_status_flag = 'Y'
     and usage_indicator in ('ALL','OS','PRM')
     order by 1 ;

Line: 464

'STATUS_CODE in (Select status_code from as_statuses_b where opp_open_status_flag=''Y'' and lead_flag = ''Y'' and enabled_flag = ''Y'') '||
'AND (sysdate - last_update_date) >  NVL(fnd_profile.value(''AST_DEFAULT_PRIOR_DAYS''),30)';

Line: 504

    Select meaning
    from ast_lookups
    where lookup_type = c_lookup_type
    and lookup_code = c_lookup_code;

Line: 512

    SELECT status_code, meaning
    FROM
      as_statuses_vl
    WHERE
      enabled_flag = 'Y' and LEAD_FLAG = 'Y' and OPP_OPEN_STATUS_FLAG = 'Y'
    ORDER BY 1;

Line: 900

'STATUS_CODE in (Select status_code from as_statuses_b where opp_open_status_flag=''Y'' and lead_flag = ''Y'' and enabled_flag = ''Y'') '||
'AND (sysdate - last_update_date) >  NVL(fnd_profile.value(''AST_DEFAULT_PRIOR_DAYS''),30)';