APPS.HZ_DSS_GRANTS_PUB dependencies on FND_OBJECTS

Line 53: fnd_objects fo

49: p_dss_group_code IN VARCHAR2
50: ) IS
51: SELECT fois.instance_set_id
52: FROM fnd_object_instance_sets fois,
53: fnd_objects fo
54: WHERE fo.obj_name = l_obj_name
55: AND fo.object_id = fois.object_id
56: AND fois.predicate LIKE '%''' || p_dss_group_code || '''%';
57:

Line 62: FROM fnd_objects

58: CURSOR c_obj (
59: p_obj_name IN VARCHAR2
60: ) IS
61: SELECT object_id
62: FROM fnd_objects
63: WHERE obj_name = p_obj_name;
64:
65: BEGIN
66:

Line 165: fnd_objects fo

161: fo.obj_name,
162: dse.status
163: FROM hz_dss_secured_entities dse,
164: fnd_object_instance_sets fois,
165: fnd_objects fo
166: WHERE dse.dss_group_code = p_dss_group_code
167: AND fois.instance_set_id = dse.dss_instance_set_id
168: AND fo.object_id = fois.object_id ;
169:

Line 584: FROM fnd_objects obj,

580: AND ROWNUM = 1;
581:
582: CURSOR c_objects IS
583: SELECT obj_name
584: FROM fnd_objects obj,
585: fnd_object_instance_sets ins
586: WHERE instance_set_id = p_dss_instance_set_id
587: AND ins.object_id = obj.object_id;
588: