APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_OBJECTS_B

Line 1302: FROM jtf_objects_b

1298: )IS SELECT select_id,
1299: select_details ,
1300: from_table ,
1301: where_clause
1302: FROM jtf_objects_b
1303: WHERE select_id is not null
1304: and select_details is not null
1305: and from_table is not null
1306: AND object_code = p_object_type;

Line 1308: l_select_id jtf_objects_b.select_id%TYPE;

1304: and select_details is not null
1305: and from_table is not null
1306: AND object_code = p_object_type;
1307:
1308: l_select_id jtf_objects_b.select_id%TYPE;
1309: l_select_details jtf_objects_b.select_details%TYPE;
1310: l_from_table jtf_objects_b.from_table%TYPE;
1311: l_where_clause jtf_objects_b.where_clause%TYPE;
1312: l_sql_statement VARCHAR2(3000);

Line 1309: l_select_details jtf_objects_b.select_details%TYPE;

1305: and from_table is not null
1306: AND object_code = p_object_type;
1307:
1308: l_select_id jtf_objects_b.select_id%TYPE;
1309: l_select_details jtf_objects_b.select_details%TYPE;
1310: l_from_table jtf_objects_b.from_table%TYPE;
1311: l_where_clause jtf_objects_b.where_clause%TYPE;
1312: l_sql_statement VARCHAR2(3000);
1313: l_details VARCHAR2(5000);

Line 1310: l_from_table jtf_objects_b.from_table%TYPE;

1306: AND object_code = p_object_type;
1307:
1308: l_select_id jtf_objects_b.select_id%TYPE;
1309: l_select_details jtf_objects_b.select_details%TYPE;
1310: l_from_table jtf_objects_b.from_table%TYPE;
1311: l_where_clause jtf_objects_b.where_clause%TYPE;
1312: l_sql_statement VARCHAR2(3000);
1313: l_details VARCHAR2(5000);
1314: l_select_id_alias jtf_objects_b.select_id%TYPE;

Line 1311: l_where_clause jtf_objects_b.where_clause%TYPE;

1307:
1308: l_select_id jtf_objects_b.select_id%TYPE;
1309: l_select_details jtf_objects_b.select_details%TYPE;
1310: l_from_table jtf_objects_b.from_table%TYPE;
1311: l_where_clause jtf_objects_b.where_clause%TYPE;
1312: l_sql_statement VARCHAR2(3000);
1313: l_details VARCHAR2(5000);
1314: l_select_id_alias jtf_objects_b.select_id%TYPE;
1315: l_select_id_value NUMBER;

Line 1314: l_select_id_alias jtf_objects_b.select_id%TYPE;

1310: l_from_table jtf_objects_b.from_table%TYPE;
1311: l_where_clause jtf_objects_b.where_clause%TYPE;
1312: l_sql_statement VARCHAR2(3000);
1313: l_details VARCHAR2(5000);
1314: l_select_id_alias jtf_objects_b.select_id%TYPE;
1315: l_select_id_value NUMBER;
1316: position NUMBER;
1317:
1318: type details_type is REF CURSOR;