APPS.AMV_WFAPPROVAL_PVT dependencies on AMV_U_ACCESS

Line 196: from amv_u_access

192: where channel_id = channel_id;
193:
194: CURSOR Sec_Approvers IS
195: select chl_approver_flag
196: from amv_u_access
197: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
198: and access_to_table_record_id = channel_id
199: and user_or_group_type = AMV_UTILITY_PVT.G_USER
200: and user_or_group_id = user_id;

Line 286: from amv_u_access

282: l_publish_flag varchar2(1);
283: --
284: CURSOR Chn_Access IS
285: select can_create_flag
286: from amv_u_access
287: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
288: and access_to_table_record_id = l_channel_id
289: and user_or_group_type = AMV_UTILITY_PVT.G_USER
290: and user_or_group_id = l_requestor_id;

Line 416: from amv_u_access

412: l_subscribe_flag varchar2(1);
413: --
414: CURSOR Chn_Access IS
415: select can_view_flag
416: from amv_u_access
417: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
418: and access_to_table_record_id = l_channel_id
419: and user_or_group_type = AMV_UTILITY_PVT.G_USER
420: and user_or_group_id = l_requestor_id;

Line 533: from amv_u_access acc

529: and CHN.CHANNEL_ID = chn_id;
530:
531: CURSOR Secn_Approvers IS
532: select fu.user_name
533: from amv_u_access acc
534: , fnd_user fu
535: where acc.access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
536: and acc.access_to_table_record_id = GetApprover.channel_id
537: and acc.user_or_group_type = AMV_UTILITY_PVT.G_USER