APPS.JTS_SETUP_FLOW_PVT SQL Statements

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

Line: 21

   SELECT parent_id
   INTO   l_flow_id
   FROM   jts_setup_flows_b
   WHERE  flow_id = p_flow_id;

Line: 37

   SELECT flow_name
   INTO   l_flow_name
   FROM   jts_setup_flows_vl
   WHERE  flow_id = p_flow_id;

Line: 60

  SELECT flow_id, flow_name, flow_type
  FROM   jts_setup_flows_vl
  WHERE  parent_id IS NULL
  AND    flow_type = C_FLOW_FLOW_TYPE;

Line: 99

  SELECT flow_id, flow_name, flow_type
  FROM  jts_setup_flows_vl
  WHERE parent_id IS NULL
  AND   flow_type = C_MODULE_FLOW_TYPE;

Line: 140

   SELECT	sb.flow_id, sv.flow_name, sb.flow_code, sb.parent_id,
		sb.mlevel, sb.flow_sequence, sb.overview_url, sb.diagnostics_url,
		sb.dpf_code, sb.dpf_asn, sb.num_steps, sb.flow_type, sb.has_child_flag
   FROM   (SELECT flow_id, flow_code, parent_id, level mlevel, flow_sequence, flow_type,
		  overview_url, diagnostics_url,
		  dpf_code, dpf_asn, num_steps, has_child_flag
	   FROM   jts_setup_flows_b
	   START WITH  flow_id = p_flow_id
	   CONNECT BY prior flow_id= parent_id) sb,
	   jts_setup_flows_vl sv
   WHERE  sv.flow_id=sb.flow_id;

Line: 195

   SELECT	sb.flow_id, sv.flow_name, sb.flow_code, sb.parent_id,
		sb.mlevel, sb.flow_sequence, sb.overview_url, sb.diagnostics_url,
		sb.dpf_code, sb.dpf_asn, sb.num_steps, sb.flow_type, sb.has_child_flag,
		vf.version_id, vf.complete_flag, vf.creation_date, vf.last_update_date,
		u1.user_name, u2.user_name
   FROM   (SELECT flow_id, level mlevel, flow_code, flow_sequence, parent_id, flow_type,
		  has_child_flag, overview_url, diagnostics_url,
		  dpf_code, dpf_asn, num_steps
	   FROM   jts_setup_flows_b
	   START WITH  flow_id = p_flow_id
	   CONNECT BY prior flow_id= parent_id) sb,
	   jts_setup_flows_vl sv,
	   jts_config_version_flows vf,
	   fnd_user u1,
	   fnd_user u2
    WHERE 	sb.flow_id=sv.flow_id
    AND  	vf.flow_id = sb.flow_id
    AND		vf.version_id = p_version_id
    AND		u1.user_id (+) = vf.created_by
    AND		u2.user_id (+) = vf.last_updated_by;