APPS.AS_LEAD_ASSIGN_WF SQL Statements

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

Line: 29

    SELECT TO_CHAR(AS_WORKFLOW_KEYS_S.nextval) INTO Item_Key FROM dual;

Line: 151

        SELECT last_update_date,
             customer_id,
             address_id,
             assign_sales_group_id,
             sales_lead_id
        FROM as_sales_leads
        WHERE sales_lead_id = x_sales_lead_id;

Line: 167

    l_last_update_date     DATE  := SYSDATE;

Line: 190

            l_sales_lead_rec.last_update_date,
            l_sales_lead_rec.customer_id,
            l_sales_lead_rec.address_id,
            l_sales_lead_rec.assign_sales_group_id,
            l_sales_lead_rec.sales_lead_id;

Line: 199

        AS_SALES_LEADS_PUB.update_sales_lead(
           p_api_version_number     => l_api_version_number
          ,p_init_msg_list          => fnd_api.g_false
          ,p_commit                 => fnd_api.g_false
          ,p_validation_level       => 0 -- fnd_api.g_valid_level_full
          ,p_check_access_flag      => 'N' -- fnd_api.g_miss_char
          ,p_admin_flag             => fnd_api.g_miss_char
          ,p_admin_group_id         => fnd_api.g_miss_num
          ,p_identity_salesforce_id => fnd_api.g_miss_num
          ,p_sales_lead_profile_tbl => l_sales_lead_profile_tbl
          ,p_sales_lead_rec         => l_sales_lead_rec
          ,x_return_status          => l_return_status
          ,x_msg_count              => l_msg_count
          ,x_msg_data               => l_msg_data );

Line: 287

        SELECT accept_flag
        FROM as_sales_leads
        WHERE sales_lead_id = lead_id_in;