DBA Data[Home] [Help]

APPS.JTF_TASK_SECURITY_PVT dependencies on JTF_TASKS_B

Line 132: jtf_tasks_b

128: fnd_menu_entries fme,
129: fnd_menus fm,
130: fnd_grants fg,
131: fnd_objects,
132: jtf_tasks_b
133: WHERE fff.function_id = fme.function_id
134: AND fme.menu_id = fm.menu_id
135: and fm.menu_id = fg.menu_id
136: and fg.instance_pk1_value = jtf_tasks_b.owner_id

Line 136: and fg.instance_pk1_value = jtf_tasks_b.owner_id

132: jtf_tasks_b
133: WHERE fff.function_id = fme.function_id
134: AND fme.menu_id = fm.menu_id
135: and fm.menu_id = fg.menu_id
136: and fg.instance_pk1_value = jtf_tasks_b.owner_id
137: and fg.instance_pk2_value = jtf_tasks_b.owner_type_code
138: and fg.grantee_key = TO_CHAR(p_resource_id)
139: and fg.object_id = fnd_objects.object_id
140: and task_id = p_task_id

Line 137: and fg.instance_pk2_value = jtf_tasks_b.owner_type_code

133: WHERE fff.function_id = fme.function_id
134: AND fme.menu_id = fm.menu_id
135: and fm.menu_id = fg.menu_id
136: and fg.instance_pk1_value = jtf_tasks_b.owner_id
137: and fg.instance_pk2_value = jtf_tasks_b.owner_type_code
138: and fg.grantee_key = TO_CHAR(p_resource_id)
139: and fg.object_id = fnd_objects.object_id
140: and task_id = p_task_id
141: and obj_name = 'JTF_TASK_RESOURCE' ;

Line 166: FROM jtf_tasks_b, jtf_objects_b

162: then
163: BEGIN
164: SELECT NVL (enter_from_task, 'N')
165: INTO x
166: FROM jtf_tasks_b, jtf_objects_b
167: WHERE task_id = p_task_id
168: AND source_object_type_code = object_code
169: AND ROWNUM < 2;
170: