APPS.ZPB_WF_EVENT SQL Statements

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

Line: 65

  select STATUS_CODE, NAME, PUBLISHED_BY
  into ACstatusCode, ACname, OwnerID
  from zpb_analysis_cycles
  where ANALYSIS_CYCLE_ID = ACID;

Line: 107

          select NAME into  l_business_area
           from zpb_business_areas_vl
           where BUSINESS_AREA_ID = l_business_area_id;

Line: 222

    select INSTANCE_DESCRIPTION
    into InstDesc
    from ZPB_ANALYSIS_CYCLE_INSTANCES
    where INSTANCE_AC_ID = InstanceID;

Line: 248

  select ACTIVITY_RESULT_CODE, ERROR_NAME, ERROR_MESSAGE
    into l_result, l_errorName, l_errormsg
    from wf_item_activity_statuses_v
    where item_type = 'ZPBSCHED' AND ACTIVITY_NAME = 'SUBMIT_CONC_REQUEST'
    AND ITEM_KEY = ItemKey;

Line: 359

select STATUS_CODE, NAME, PUBLISHED_BY, BUSINESS_AREA_ID
into ACstatusCode, ACname, OwnerID, l_business_area_id
from zpb_analysis_cycles
where ANALYSIS_CYCLE_ID = ACID;

Line: 378

select min(RESPONSIBILITY_ID)
into respID
from FND_USER_RESP_GROUPS g
where USER_ID = OwnerID and RESPONSIBILITY_APPLICATION_ID = respAppID
and g.RESPONSIBILITY_ID in (select r.RESPONSIBILITY_ID
from FND_RESPONSIBILITY r where RESPONSIBILITY_KEY in
('ZPB_CONTROLLER_RESP', 'ZPB_SUPER_CONTROLLER_RESP', 'ZPB_MANAGER_RESP'));

Line: 425

   l_parameter_list.DELETE;

Line: 453

    select user_id
    from ZPB_BP_EXTERNAL_USERS
    where ANALYSIS_CYCLE_ID = ACID;