[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT object_id
INTO l_object_id
FROM fnd_objects
WHERE obj_name = p_object_name;
SELECT 'HZ_GROUP:'||group_membership_rel.object_id group_name
FROM hz_relationships group_membership_rel
WHERE group_membership_rel.RELATIONSHIP_CODE = 'MEMBER_OF'
AND group_membership_rel.status= 'A'
AND group_membership_rel.start_date <= SYSDATE
AND NVL(group_membership_rel.end_date, SYSDATE) >= SYSDATE
AND group_membership_rel.subject_id = cp_orig_system_id;
SELECT 'HZ_COMPANY:'||group_membership_rel.object_id company_name
FROM hz_relationships group_membership_rel
WHERE group_membership_rel.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
AND group_membership_rel.status = 'A'
AND group_membership_rel.start_date <= SYSDATE
AND NVL(group_membership_rel.end_date, SYSDATE) >= SYSDATE
AND group_membership_rel.subject_id = cp_orig_system_id;
SELECT person_party_id INTO l_party_id
FROM fnd_user users
WHERE users.user_id = l_user_id;
'SELECT DISTINCT fnd_functions.function_name ' ||
' FROM fnd_grants grants, ' ||
' fnd_form_functions fnd_functions, ' ||
' fnd_menu_entries cmf, '||
' fnd_object_instance_sets sets ' ||
' WHERE grants.object_id = :object_id ' ||
' AND grants.start_date <= SYSDATE ' ||
' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
' AND ( ( grants.grantee_type = ''USER'' AND ' ||
' grants.grantee_key = :user_name ) '||
' OR (grants.grantee_type = ''GROUP'' AND ' ||
' grants.grantee_key in ( '||l_group_info||' )) ' ||
' OR (grants.grantee_type = ''COMPANY'' AND ' ||
' grants.grantee_key in ( '||l_company_info||' )) ' ||
' OR (grants.grantee_type = ''GLOBAL'' AND ' ||
' grants.grantee_key in (''HZ_GLOBAL:-1000'', ''GLOBAL'') ))' ||
' AND cmf.function_id = fnd_functions.function_id ' ||
' AND cmf.menu_id = grants.menu_id ' ||
' AND grants.instance_set_id = sets.instance_set_id ' ||
' AND grants.instance_type = ''SET'' ' ||
' AND sets.instance_set_name = ''ORGANIZATION'' '; -- Users need to set up it during grant process