DBA Data[Home] [Help]

APPS.JTF_TASK_OBJECT_MIGRATION_PUB dependencies on JTF_OBJECTS_B

Line 13: FROM jtf_objects_b

9: ,x_return_status OUT NOCOPY VARCHAR2)
10: IS
11: CURSOR c_object IS
12: SELECT select_id, select_name, from_table, where_clause
13: FROM jtf_objects_b
14: WHERE object_code = p_object_code;
15:
16: l_id_column jtf_objects_b.select_id%TYPE;
17: l_name_column jtf_objects_b.select_name%TYPE;

Line 16: l_id_column jtf_objects_b.select_id%TYPE;

12: SELECT select_id, select_name, from_table, where_clause
13: FROM jtf_objects_b
14: WHERE object_code = p_object_code;
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:

Line 17: l_name_column jtf_objects_b.select_name%TYPE;

13: FROM jtf_objects_b
14: WHERE object_code = p_object_code;
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:
21: l_stmt VARCHAR2(1000);

Line 18: l_from_clause jtf_objects_b.from_table%TYPE;

14: WHERE object_code = p_object_code;
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:
21: l_stmt VARCHAR2(1000);
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:
21: l_stmt VARCHAR2(1000);
22:
23: BEGIN