DBA Data[Home] [Help]

APPS.AMV_UTILITY_PVT2 dependencies on AMV_U_ACCESS

Line 164: from amv_u_access

160: l_flag varchar2(1);
161:
162: CURSOR DelChanAccs_csr IS
163: select can_delete_flag
164: from amv_u_access
165: where access_to_table_code = AMV_UTILITY_PVT2.G_CHANNEL
166: and access_to_table_record_id = p_channel_id
167: and user_or_group_id = p_user_or_group_id
168: and user_or_group_type = p_user_or_group_type;

Line 217: from amv_u_access

213: l_flag varchar2(1);
214:
215: CURSOR UpdChanAccs_csr IS
216: select can_update_flag
217: from amv_u_access
218: where access_to_table_code = AMV_UTILITY_PVT2.G_CHANNEL
219: and access_to_table_record_id = p_channel_id
220: and user_or_group_id = p_user_or_group_id
221: and user_or_group_type = p_user_or_group_type;

Line 271: from amv_u_access

267: l_flag varchar2(1);
268:
269: CURSOR DelCatAccs_csr IS
270: select can_delete_flag
271: from amv_u_access
272: where access_to_table_code = AMV_UTILITY_PVT2.G_CATEGORY
273: and access_to_table_record_id = p_category_id
274: and user_or_group_id = p_user_or_group_id
275: and user_or_group_type = p_user_or_group_type;

Line 324: from amv_u_access

320: l_flag varchar2(1);
321:
322: CURSOR UpdCatAccs_csr IS
323: select can_update_flag
324: from amv_u_access
325: where access_to_table_code = AMV_UTILITY_PVT2.G_CATEGORY
326: and access_to_table_record_id = p_category_id
327: and user_or_group_id = p_user_or_group_id
328: and user_or_group_type = p_user_or_group_type;