APPS.AS_SALES_LEAD_AGING_CONC_PUB SQL Statements

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

Line: 44

        SELECT sales_lead_id, assign_to_salesforce_id
        FROM as_sales_leads
        WHERE nvl(status_code, 'NULL') <> 'DECLINED'
        AND nvl(deleted_flag,'NULL')  <> 'Y';

Line: 143

        SELECT assign_to_salesforce_id
        FROM as_sales_leads
        WHERE sales_lead_id = sales_lead_id_in;