DBA Data[Home] [Help]

APPS.POS_DATA_SECURITY dependencies on FND_GRANTS

Line 106: l_user_name FND_GRANTS.GRANTEE_KEY%TYPE;

102:
103: l_user_id NUMBER;
104: l_party_id NUMBER;
105: l_role_name VARCHAR2(99);
106: l_user_name FND_GRANTS.GRANTEE_KEY%TYPE;
107:
108: l_index NUMBER;
109: l_dynamic_sql VARCHAR2(32767);
110: l_privilege VARCHAR2(480);

Line 182: ' FROM fnd_grants grants, ' ||

178: l_company_info := get_company_info(p_party_id => l_party_id);
179:
180: l_dynamic_sql :=
181: 'SELECT DISTINCT fnd_functions.function_name ' ||
182: ' FROM fnd_grants grants, ' ||
183: ' fnd_form_functions fnd_functions, ' ||
184: ' fnd_menu_entries cmf, '||
185: ' fnd_object_instance_sets sets ' ||
186: ' WHERE grants.object_id = :object_id ' ||