DBA Data[Home] [Help]

APPS.CN_CW_WORKBENCH_UTILITY SQL Statements

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

Line: 15

  SELECT setup_task_status
  FROM   CN_CW_SETUP_TASKS_VL
  where org_id=p_org_id and workbench_item_code='APPLICATION_PARAMETERS' and
  setup_task_code in('GENERAL_SETTINGS','GENERAL_LEDGER_SETTINGS');
Line: 87

  SELECT setup_task_status
  FROM   CN_CW_SETUP_TASKS_VL
  WHERE  workbench_item_code = p_workbench_item_code and org_id =p_org_id
  ORDER BY setup_task_status;