APPS.ZPB_SC_REASSIGN SQL Statements

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

Line: 53

  UPDATE
   zpb_analysis_cycles
  SET
   owner_id = p_new_owner_id,
   last_updated_by = fnd_global.USER_ID,
   last_update_date = SYSDATE,
   last_update_login = fnd_global.LOGIN_ID
  WHERE
   owner_id = p_owner_id AND
   business_area_id =  p_business_area_id;

Line: 84

    SELECT
      name
    FROM
      zpb_analysis_cycles
    WHERE
      owner_id = p_owner_id AND
      business_area_id =  p_business_area_id AND
      status_code in ('DISABLE_ASAP', 'ENABLE_TASK', 'ERROR',
                      'MARKED_FOR_DELETION', 'PAUSED', 'PAUSING', 'PUBLISHED',
                      'WARNING', 'ACTIVE');

Line: 129

    SELECT
      template_name
    FROM
      zpb_dc_objects
    WHERE
      object_user_id = p_owner_id AND
      object_type IN ('W', 'C') AND
      business_area_id = p_business_area_id;

Line: 181

  SELECT user_name INTO l_new_owner_user_name FROM fnd_user WHERE user_id = p_new_owner_id;

Line: 182

  SELECT user_name INTO l_owner_user_name FROM fnd_user WHERE user_id = p_owner_id;

Line: 185

 UPDATE
   zpb_analysis_cycle_tasks
  SET
   owner_id = p_new_owner_id,
   last_updated_by = fnd_global.USER_ID,
   last_update_date = SYSDATE,
   last_update_login = fnd_global.LOGIN_ID
  WHERE
   owner_id = p_owner_id and
   analysis_cycle_id in (SELECT
                          distinct(ZACT.analysis_cycle_id)
                         FROM
                          zpb_analysis_cycle_tasks ZACT,
                          zpb_analysis_cycles ZAC
                         WHERE
                          ZACT.analysis_cycle_id =
                          ZAC.analysis_cycle_id and
                          ZAC.business_area_id = p_business_area_id);

Line: 206

  UPDATE
   zpb_task_parameters
  SET
   value = p_new_owner_id,
   last_updated_by = fnd_global.USER_ID,
   last_update_date = SYSDATE,
   last_update_login = fnd_global.LOGIN_ID
  WHERE
   name = 'OWNER_ID' and
   value = p_owner_id and
   task_id in (SELECT
                 ZTP.task_id
               FROM
                 zpb_task_parameters ZTP,
                 zpb_analysis_cycle_tasks ZACT,
                 zpb_analysis_cycles ZAC
               WHERE
                 ZTP.task_id = ZACT.task_id and
                 ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
                 ZAC.business_area_id = p_business_area_id);

Line: 228

  UPDATE
   zpb_task_parameters
  SET
   value = l_new_owner_user_name,
   last_updated_by = fnd_global.USER_ID,
   last_update_date = SYSDATE,
   last_update_login = fnd_global.LOGIN_ID
  WHERE
   name = 'SPECIFIED_NOTIFICATION_RECIPIENT' and
   value = l_owner_user_name and
   task_id in (SELECT
                 ZTP.task_id
               FROM
                 zpb_task_parameters ZTP,
                 zpb_analysis_cycle_tasks ZACT,
                 zpb_analysis_cycles ZAC
               WHERE
                 ZTP.task_id = ZACT.task_id and
                 ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
                 ZAC.business_area_id = p_business_area_id);

Line: 250

  UPDATE
   zpb_excp_results
  SET
   owner_id = p_new_owner_id,
   owner = l_new_owner_user_name,
   last_updated_by = fnd_global.USER_ID,
   last_update_date = SYSDATE,
   last_update_login = fnd_global.LOGIN_ID
  WHERE
   owner_id = p_owner_id and
   task_id in (SELECT
                 ZTP.task_id
               FROM
                 zpb_task_parameters ZTP,
                 zpb_analysis_cycle_tasks ZACT,
                 zpb_analysis_cycles ZAC
               WHERE
                 ZTP.task_id = ZACT.task_id and
                 ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
                 ZAC.business_area_id = p_business_area_id);

Line: 272

  UPDATE
   zpb_excp_results
  SET
   approver_id = p_new_owner_id,
   approver = l_new_owner_user_name,
   last_updated_by = fnd_global.USER_ID,
   last_update_date = SYSDATE,
   last_update_login = fnd_global.LOGIN_ID
  WHERE
   approver_id = p_owner_id and
   task_id in (SELECT
                 ZTP.task_id
               FROM
                 zpb_task_parameters ZTP,
                 zpb_analysis_cycle_tasks ZACT,
                 zpb_analysis_cycles ZAC
               WHERE
                 ZTP.task_id = ZACT.task_id and
                 ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
                 ZAC.business_area_id = p_business_area_id);

Line: 294

 UPDATE
   zpb_excp_explanations
  SET
   owner_id = p_new_owner_id,
   owner = l_new_owner_user_name,
   last_updated_by = fnd_global.USER_ID,
   last_update_date = SYSDATE,
   last_update_login = fnd_global.LOGIN_ID
  WHERE
   owner_id = p_owner_id and
   task_id in (SELECT
                 ZTP.task_id
               FROM
                 zpb_task_parameters ZTP,
                 zpb_analysis_cycle_tasks ZACT,
                 zpb_analysis_cycles ZAC
               WHERE
                 ZTP.task_id = ZACT.task_id and
                 ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
                 ZAC.business_area_id = p_business_area_id);

Line: 317

  UPDATE
   zpb_excp_explanations
  SET
   approver_id = p_new_owner_id,
   approver = l_new_owner_user_name,
   last_updated_by = fnd_global.USER_ID,
   last_update_date = SYSDATE,
   last_update_login = fnd_global.LOGIN_ID
  WHERE
   approver_id = p_owner_id and
   task_id in (SELECT
                 ZTP.task_id
               FROM
                 zpb_task_parameters ZTP,
                 zpb_analysis_cycle_tasks ZACT,
                 zpb_analysis_cycles ZAC
               WHERE
                 ZTP.task_id = ZACT.task_id and
                 ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
                 ZAC.business_area_id = p_business_area_id);