APPS.JTS_SETUP_FLOW_PVT dependencies on JTS_SETUP_FLOWS_B

Line 19: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;

15:
16: -- Returns the flow id of a flow's parent
17: FUNCTION GET_PARENT_FLOW_ID(p_flow_id IN NUMBER)
18: RETURN NUMBER IS
19: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
20: BEGIN
21: SELECT parent_id
22: INTO l_flow_id
23: FROM jts_setup_flows_b

Line 23: FROM jts_setup_flows_b

19: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
20: BEGIN
21: SELECT parent_id
22: INTO l_flow_id
23: FROM jts_setup_flows_b
24: WHERE flow_id = p_flow_id;
25:
26: return (l_flow_id);
27: EXCEPTION

Line 146: FROM jts_setup_flows_b

142: sb.dpf_code, sb.dpf_asn, sb.num_steps, sb.flow_type, sb.has_child_flag
143: FROM (SELECT flow_id, flow_code, parent_id, level mlevel, flow_sequence, flow_type,
144: overview_url, diagnostics_url,
145: dpf_code, dpf_asn, num_steps, has_child_flag
146: FROM jts_setup_flows_b
147: START WITH flow_id = p_flow_id
148: CONNECT BY prior flow_id= parent_id) sb,
149: jts_setup_flows_vl sv
150: WHERE sv.flow_id=sb.flow_id;

Line 203: FROM jts_setup_flows_b

199: u1.user_name, u2.user_name
200: FROM (SELECT flow_id, level mlevel, flow_code, flow_sequence, parent_id, flow_type,
201: has_child_flag, overview_url, diagnostics_url,
202: dpf_code, dpf_asn, num_steps
203: FROM jts_setup_flows_b
204: START WITH flow_id = p_flow_id
205: CONNECT BY prior flow_id= parent_id) sb,
206: jts_setup_flows_vl sv,
207: jts_config_version_flows vf,