APPS.ZPB_DVAC_WF SQL Statements

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

Line: 18

     select a.user_id, a.exemption_id
      from zpb_measure_scope_exempt_users a
      where business_process_entity_type = 'A'
       -- bug 4587184
       -- and business_process_entity_id = BP_ID
       and business_process_entity_id = instanceId
       and task_id = p_task_id;

Line: 43

        delete from ZPB_MEASURE_SCOPE
          where INSTANCE_AC_ID = l_instance_ac_Id;

Line: 47

	insert into ZPB_MEASURE_SCOPE
          (INSTANCE_AC_ID,
           RESTRICTION_TYPE,
           START_TIME_TYPE,
           START_TIME_MEMBER_ID,
           START_RELATIVE_TYPE_CODE,
           START_PERIODS,
           START_TIME_LEVEL_ID,
           END_TIME_TYPE,
           END_TIME_MEMBER_ID,
           END_RELATIVE_TYPE_CODE,
           END_PERIODS,
           END_TIME_LEVEL_ID,
           TIME_HIERARCHY_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN)
         select
           -- bug 4587184: replace with BP_ID since where statement has changed
           -- ANALYSIS_CYCLE_ID,
           BP_ID,
           RESTRICTION_TYPE,
           START_TIME_TYPE,
           START_TIME_MEMBER_ID,
           START_RELATIVE_TYPE_CODE,
           START_PERIODS,
           START_TIME_LEVEL_ID,
           END_TIME_TYPE,
           END_TIME_MEMBER_ID,
           END_RELATIVE_TYPE_CODE,
           END_PERIODS,
           END_TIME_LEVEL_ID,
           TIME_HIERARCHY_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN
         from ZPB_BUSINESS_PROCESS_SCOPE
           -- bug 4587184: Replace BP_ID with instanceId
           -- where ANALYSIS_CYCLE_ID = BP_ID
           where ANALYSIS_CYCLE_ID = instanceId
           and   TASK_ID = p_task_id;

Line: 94

        update ZPB_MEASURE_SCOPE
          set INSTANCE_AC_ID = l_instance_ac_id,
              CREATED_BY = fnd_global.USER_ID,
              CREATION_DATE = SYSDATE,
              LAST_UPDATED_BY = fnd_global.USER_ID,
              LAST_UPDATE_DATE = SYSDATE,
              LAST_UPDATE_LOGIN = fnd_global.USER_ID
          where INSTANCE_AC_ID = BP_ID;

Line: 105

        delete from ZPB_MEASURE_SCOPE_EXEMPT_USERS
          where BUSINESS_PROCESS_ENTITY_ID = l_instance_ac_id
          and BUSINESS_PROCESS_ENTITY_TYPE = 'I';

Line: 112

           insert into zpb_measure_scope_exempt_users
              (user_id, exemption_id, business_process_entity_id,
                business_process_entity_type, created_by, creation_date,
                last_updated_by, last_update_date, last_update_login)
           values(each.user_id, each.exemption_id, l_instance_ac_id, 'I',
                fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
                SYSDATE, fnd_global.LOGIN_ID);

Line: 124

	ZPB_AW.EXECUTE('UPDATE');