DBA Data[Home] [Help]

APPS.CAC_SR_UTIL_PVT dependencies on JTF_OBJECTS_B

Line 11: FROM jtf_objects_b

7: RETURN VARCHAR2 is
8: CURSOR c_references (p_object_type_code VARCHAR2)
9: IS
10: SELECT select_id, select_name, from_table, where_clause
11: FROM jtf_objects_b
12: WHERE object_code = p_object_type_code;
13: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
14:
15:

Line 16: l_id_column jtf_objects_b.select_id%TYPE;

12: WHERE object_code = p_object_type_code;
13: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
14:
15:
16: l_id_column jtf_objects_b.select_id%TYPE;
17: l_name_column jtf_objects_b.select_name%TYPE;
18: l_from_clause jtf_objects_b.from_table%TYPE;
19: l_where_clause jtf_objects_b.where_clause%TYPE;
20: l_object_name VARCHAR2(2000);

Line 17: l_name_column jtf_objects_b.select_name%TYPE;

13: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
14:
15:
16: l_id_column jtf_objects_b.select_id%TYPE;
17: l_name_column jtf_objects_b.select_name%TYPE;
18: l_from_clause jtf_objects_b.from_table%TYPE;
19: l_where_clause jtf_objects_b.where_clause%TYPE;
20: l_object_name VARCHAR2(2000);
21: sql_stmt VARCHAR2(2000);

Line 18: l_from_clause jtf_objects_b.from_table%TYPE;

14:
15:
16: l_id_column jtf_objects_b.select_id%TYPE;
17: l_name_column jtf_objects_b.select_name%TYPE;
18: l_from_clause jtf_objects_b.from_table%TYPE;
19: l_where_clause jtf_objects_b.where_clause%TYPE;
20: l_object_name VARCHAR2(2000);
21: sql_stmt VARCHAR2(2000);
22:

Line 19: l_where_clause jtf_objects_b.where_clause%TYPE;

15:
16: l_id_column jtf_objects_b.select_id%TYPE;
17: l_name_column jtf_objects_b.select_name%TYPE;
18: l_from_clause jtf_objects_b.from_table%TYPE;
19: l_where_clause jtf_objects_b.where_clause%TYPE;
20: l_object_name VARCHAR2(2000);
21: sql_stmt VARCHAR2(2000);
22:
23: BEGIN