APPS.AS_LEAD_ROUTING_WF_CUHK SQL Statements

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

Line: 114

      SELECT acc.salesforce_id, acc.sales_group_id
      FROM as_accesses_all acc, as_territory_accesses terracc,
           jtf_terr_rsc_all terrrsc
      WHERE acc.sales_lead_id = c_sales_lead_id
      AND acc.created_by_tap_flag = 'Y'
      AND acc.access_id = terracc.access_id
      AND terracc.territory_id = terrrsc.terr_id
      AND terrrsc.resource_id = acc.salesforce_id
      AND terrrsc.role = 'TELESALES_AGENT'
      ORDER BY acc.access_id;

Line: 128

      SELECT acc.salesforce_id, acc.sales_group_id
      FROM as_accesses_all acc
      WHERE acc.sales_lead_id = c_sales_lead_id
      AND acc.created_by_tap_flag = 'Y'
      ORDER BY acc.access_id;

Line: 138

      SELECT res.source_id
      FROM jtf_rs_resource_extns res
      WHERE res.resource_id = c_resource_id;

Line: 143

      SELECT SL.CUSTOMER_ID, SL.ADDRESS_ID
      FROM AS_SALES_LEADS SL
      WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;