DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on JTF_OBJECTS_VL

Line 413: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.

409: IS
410: SELECT select_id, select_name, from_table, where_clause
411: FROM jtf_objects_b
412: WHERE object_code = p_object_type_code;
413: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
414:
415:
416: l_id_column jtf_objects_b.select_id%TYPE;
417: l_name_column jtf_objects_b.select_name%TYPE;

Line 721: FROM jtf_objects_vl

717:
718: CURSOR c_object_type_name
719: IS
720: SELECT object_code
721: FROM jtf_objects_vl
722: WHERE name = p_object_type_name
723: AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
724: AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE)
725: AND (object_code IN

Line 2201: FROM jtf_objects_vl

2197:
2198: CURSOR c_object_type_name
2199: IS
2200: SELECT object_code
2201: FROM jtf_objects_vl
2202: WHERE name = p_object_type_name;
2203:
2204: BEGIN
2205: x_return_status := fnd_api.g_ret_sts_success;

Line 2814: FROM jtf_objects_vl

2810: IF (x_owner_name IS NOT NULL)
2811: THEN
2812: SELECT name
2813: INTO x_owner_type_code_name
2814: FROM jtf_objects_vl
2815: WHERE object_code = x_owner_type_code;
2816: RETURN;
2817: ELSE
2818: BEGIN

Line 2834: FROM jtf_objects_vl

2830: FROM jtf_rs_resource_extns
2831: WHERE user_id = fnd_global.user_id;
2832: SELECT name
2833: INTO x_owner_type_code_name
2834: FROM jtf_objects_vl
2835: WHERE object_code = x_owner_type_code;
2836: x_owner_name :=
2837: jtf_task_utl.get_owner (x_owner_type_code, x_owner_id);
2838: EXCEPTION

Line 4626: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.

4622: IS
4623: SELECT select_id, select_details, from_table, where_clause
4624: FROM jtf_objects_b
4625: WHERE object_code = p_object_type_code;
4626: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
4627:
4628:
4629: l_id_column jtf_objects_b.select_id%TYPE;
4630: l_details_column jtf_objects_b.select_details%TYPE;