APPS.ZPB_DC_DISTRIBUTE SQL Statements

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

Line: 44

  SELECT distinct object_user_id,
                business_area_id
   FROM ZPB_DC_OBJECTS
   WHERE status = 'DISTRIBUTION_PENDING'
   --AND object_user_id = 1009108
   --AND business_area_id = 22
   AND object_type in ('W','C');

Line: 82

      SELECT  fugp.responsibility_id
        INTO  l_resp_id
        FROM  fnd_user_resp_groups fugp, fnd_responsibility fr
        WHERE responsibility_application_id = 210
        AND  fugp.responsibility_id = fr.responsibility_id
        AND user_id = l_user_id
        AND responsibility_key IN ('ZPB_CONTROLLER_RESP', 'ZPB_SUPER_CONTROLLER_RESP', 'ZPB_ANALYST_RESP')
        AND ROWNUM = 1;

Line: 192

   SELECT template_id,distributor_user_id,
          copy_instance_data_flag,
          copy_target_data_flag,
          view_type,
          create_instance_measures_flag,
          create_solve_program_flag,
          object_type,
          object_id,
          currency_flag,
          ac_instance_id,
          generate_template_task_id
    FROM zpb_dc_objects
    WHERE status = 'DISTRIBUTION_PENDING'
    AND object_type in ('W','C')
    AND object_user_id = p_user_id
    AND business_area_id = p_business_area_id;

Line: 267

   UPDATE zpb_users
     SET conc_request_id = l_conc_request_id,
      conc_request_start_time = SYSDATE,
     -- WHO columns
     last_update_date        = SYSDATE,
     last_updated_by         = fnd_global.user_id,
     last_update_login       = fnd_global.LOGIN_ID
     WHERE user_id = p_user_id
     AND business_area_id = p_business_area_id;

Line: 309

               SELECT view_type
               INTO l_currency_view
               FROM zpb_dc_objects
               WHERE template_id = l_template_id
               AND object_user_id = l_distributor_user_id
               AND object_type in ('W','C');

Line: 371

       UPDATE zpb_dc_objects
        SET view_type = l_currency_view,
        -- WHO columns
        last_update_date        = SYSDATE,
        last_updated_by         = fnd_global.user_id,
        last_update_login       = fnd_global.LOGIN_ID
      WHERE template_id = l_template_id
      AND object_user_id = p_user_id;

Line: 399

   UPDATE zpb_users
     SET conc_request_id  = NULL,
     conc_request_start_time = NULL,
     -- WHO columns
     last_update_date        = SYSDATE,
     last_updated_by         = fnd_global.user_id,
     last_update_login       = fnd_global.LOGIN_ID
     WHERE user_id = p_user_id
     AND business_area_id = p_business_area_id;