APPS.UMX_REG_FLOW_PVT SQL Statements

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

Line: 53

 select UMX.reg_service_type, UMX.reg_function_id, UMX.end_date, f.function_id
 from umx_reg_services_b umx, fnd_form_functions f
 where UMX.reg_service_code = p_regSrv
 and UMX.reg_function_id = f.function_id(+);

Line: 136

      SELECT application_id
      INTO l_application_id
      FROM fnd_application
      WHERE application_short_name = 'FND';

Line: 141

      SELECT function_id
      INTO l_function_id
      FROM fnd_form_functions
      WHERE function_name = 'UMX_FLOW_LAUNCHER';

Line: 179

      SELECT application_id
      INTO l_application_id
      FROM fnd_application
      WHERE application_short_name = 'FND';

Line: 184

      SELECT function_id
      INTO l_function_id
      FROM fnd_form_functions
      WHERE function_name = 'UMX_FLOW_LAUNCHER';