APPS.ZPB_WFMNT SQL Statements

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

Line: 16

   select instance_ac_id
   from zpb_analysis_cycle_instances
   where analysis_cycle_id = l_thisACID;

Line: 23

   select ANALYSIS_CYCLE_ID
     from ZPB_ANALYSIS_CYCLES
     where BUSINESS_AREA_ID = p_business_area_id;

Line: 41

         delete from zpb_excp_results re
          where re.task_id in (select pd.task_id from zpb_process_details_v pd
          where analysis_cycle_id = l_thisInst);

Line: 44

         delete from zpb_excp_explanations ex
          where ex.task_id in (select pd.task_id from zpb_process_details_v pd
          where analysis_cycle_id = l_thisInst);

Line: 79

        select item_type, item_key
           from WF_ITEM_ATTRIBUTE_VALUES
           where (item_type = 'ZPBSCHED' OR item_type = 'EPBCYCLE')
           and   name = AttrName
           and   number_value = p_inACID;

Line: 89

   select w.item_key
    from ZPB_DC_OBJECTS d,
    WF_ITEM_ATTRIBUTE_VALUES w
    where analysis_cycle_id = p_inACID
    and (w.item_type = 'EPBDC')
    and  w.name = 'DC_OBJECT_ID'
    and  w.number_value = d.object_id;