APPS.HZ_DSS_UTIL_PUB dependencies on FND_OBJECT_INSTANCE_SETS

Line 562: fnd_object_instance_sets ins

558: FROM hz_dss_entities dse,
559: hz_dss_secured_entities se,
560: hz_dss_groups_b dsg,
561: fnd_objects obj,
562: fnd_object_instance_sets ins
563: WHERE obj.database_object_name = p_db_object_name
564: AND dse.object_id IS NULL
565: AND dse.instance_set_id = ins.instance_set_id
566: AND ins.object_id = obj.object_id

Line 977: from fnd_object_instance_sets ois

973: WHERE ( ( dse.object_id IN ( select object_id from fnd_objects
974: where database_object_name = t_object_name) )
975: OR
976: (dse.instance_set_id in ( select instance_set_id
977: from fnd_object_instance_sets ois
978: where ois.object_id IN
979: (select object_id from fnd_objects
980: where database_object_name = t_object_name)
981: )

Line 1112: fo.object_id = ( select distinct object_id from fnd_object_instance_sets

1108: WHERE parent_entity_id is not null
1109: AND ( dse.object_id is not null and
1110: fo.object_id = dse.object_id )
1111: OR (dse.instance_set_id is not null and
1112: fo.object_id = ( select distinct object_id from fnd_object_instance_sets
1113: where instance_set_id = dse.instance_set_id))
1114: AND dse.parent_entity_id = t_entity_id
1115: AND dse.status = 'A'
1116: order by dse.entity_id;

Line 1370: FROM fnd_object_instance_sets ins,

1366: decode(pk2_column_name , null,null, ','|| pk2_column_name) ||
1367: decode(pk3_column_name , null,null, ','|| pk3_column_name) ||
1368: decode(pk4_column_name , null,null, ','|| pk4_column_name) ||
1369: decode(pk5_column_name , null,null, ','|| pk5_column_name)
1370: FROM fnd_object_instance_sets ins,
1371: fnd_objects obj,
1372: hz_dss_entities dse
1373: WHERE dse.entity_id = p_entity_id
1374: AND dse.status = 'A'

Line 2426: FROM fnd_object_instance_sets_vl

2422: WHERE obj_name = p_object_name;
2423:
2424: CURSOR c_object_instance_sets IS
2425: SELECT display_name
2426: FROM fnd_object_instance_sets_vl
2427: WHERE instance_set_name = p_object_instance_name;
2428:
2429: l_return VARCHAR2(300);
2430: