APPS.ZPB_PUBLISH SQL Statements

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

Line: 50

            select *
            from zpb_analysis_cycle_tasks
            where ANALYSIS_CYCLE_ID = InstanceID
            and Sequence = CurrtaskSeq;

Line: 205

          select NAME, value
          from ZPB_TASK_PARAMETERS
          where TASK_ID = TaskID and name = 'SPECIFIED_NOTIFICATION_RECIPIENT';

Line: 212

          select NAME, value
          from ZPB_TASK_PARAMETERS
          where TASK_ID = TaskID and name = 'TEMPLATE_DATASOURCE';

Line: 281

        SELECT value INTO template_name
        FROM zpb_task_parameters
        WHERE task_ID = taskID and NAME = 'DOCUMENT_TEMPLATE_NAME';

Line: 286

        SELECT value INTO read_access
        FROM zpb_task_parameters
        WHERE task_ID = taskID and NAME = 'DOCUMENT_SECURITY';

Line: 296

        SELECT value INTO appr_flag
        FROM zpb_task_parameters
        WHERE task_ID = taskID and NAME = 'DOCUMENT_WAIT_FOR_APPROVAL';

Line: 301

        SELECT value INTO send_status_flag
        FROM zpb_task_parameters
        WHERE task_ID = taskID and NAME = 'DOCUMENT_SEND_STATUS_BPO';