APPS.EGO_VALID_INSTANCE_SET_GRANTS dependencies on FND_OBJECTS

Line 40: fnd_objects obj

36: sets.predicate predicate
37: from
38: fnd_grants grants,
39: fnd_object_instance_sets sets,
40: fnd_objects obj
41: where obj.obj_name = p_obj_name
42: AND grants.object_id = obj.object_id
43: AND grants.instance_type='SET'
44: AND grants.parameter1 is null

Line 53: PK5_COLUMN_NAME from fnd_objects where OBJ_NAME = p_obj_name;

49: CURSOR obj_meta_data IS
50: select DATABASE_OBJECT_NAME,
51: PK1_COLUMN_NAME,PK2_COLUMN_NAME,
52: PK3_COLUMN_NAME,PK4_COLUMN_NAME,
53: PK5_COLUMN_NAME from fnd_objects where OBJ_NAME = p_obj_name;
54: obj_meta_data_rec obj_meta_data%ROWTYPE;
55: i NUMBER := 1;
56: -- bug 3748547 setting varchar2 fields to maximum size
57: query_to_exec VARCHAR2(32767);