DBA Data[Home] [Help]

APPS.JTF_TASK_SECURITY_PVT dependencies on FND_OBJECTS

Line 131: fnd_objects,

127: FROM fnd_form_functions fff,
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

Line 139: and fg.object_id = fnd_objects.object_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' ;
142:
143:

Line 400: fnd_objects

396: FROM fnd_form_functions fff,
397: fnd_menu_entries fme,
398: fnd_menus fm,
399: fnd_grants fg,
400: fnd_objects
401: WHERE fff.function_id = fme.function_id
402: AND fme.menu_id = fm.menu_id
403: and fm.menu_id = fg.menu_id
404: and fg.instance_pk1_value = priveleges_from_resource_id

Line 407: and fg.object_id = fnd_objects.object_id

403: and fm.menu_id = fg.menu_id
404: and fg.instance_pk1_value = priveleges_from_resource_id
405: and fg.instance_pk2_value = priveleges_from_resource_type
406: and fg.grantee_key = TO_CHAR(logged_in_resource)
407: and fg.object_id = fnd_objects.object_id
408: and obj_name = 'JTF_TASK_RESOURCE' ;
409:
410: return l_privlege_name ;
411: exception