DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on FND_OBJECTS

Line 475: ,fnd_objects o

471: jtf_rs_groups_denorm d
472: ,jtf_rs_group_members m
473: ,jtf_rs_resource_extns e
474: ,fnd_grants g
475: ,fnd_objects o
476: WHERE d.parent_group_id = g.parameter2
477: AND TRUNC(SYSDATE)
478: BETWEEN d.start_date_active
479: AND NVL(d.end_date_active,TRUNC(SYSDATE))

Line 497: ,fnd_objects o

493: SELECT
494: NULL
495: FROM
496: fnd_grants g
497: ,fnd_objects o
498: WHERE g.object_id = o.object_id
499: AND o.obj_name = G_OBJECT_NAME
500: AND g.grantee_type = G_FND_GRANTEE_TYPE_USER
501: AND g.instance_pk1_value = p_contract_id2