APPS.AMV_WFAPPROVAL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36

select 	channel_name
from		amv_c_channels_vl
where	channel_id = ChannelId;

Line: 41

select 	item_name
from		jtf_amv_items_vl
where	item_id = ItemId;

Line: 46

select FND.USER_NAME
from   JTF_RS_RESOURCE_EXTNS RD
,      FND_USER FND
where RD.USER_ID = FND.USER_ID
and   RD.RESOURCE_ID = RequestorId;

Line: 53

select amv_wf_requests_s.nextval
from dual;

Line: 189

select	default_approver_user_id
,		owner_user_id
from		amv_c_channels_b
where	channel_id = channel_id;

Line: 195

select	chl_approver_flag
from		amv_u_access
where	access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
and		access_to_table_record_id = channel_id
and		user_or_group_type = AMV_UTILITY_PVT.G_USER
and		user_or_group_id = user_id;

Line: 285

select	can_create_flag
from		amv_u_access
where	access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
and		access_to_table_record_id = l_channel_id
and		user_or_group_type = AMV_UTILITY_PVT.G_USER
and		user_or_group_id = l_requestor_id;

Line: 293

select  	pub_need_approval_flag
from		amv_c_channels_b
where	channel_id = l_channel_id;

Line: 415

select	can_view_flag
from		amv_u_access
where	access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
and		access_to_table_record_id = l_channel_id
and		user_or_group_type = AMV_UTILITY_PVT.G_USER
and		user_or_group_id = l_requestor_id;

Line: 423

select  	sub_need_approval_flag
from		amv_c_channels_b
where	channel_id = l_channel_id;

Line: 523

select FND1.USER_NAME
from JTF_RS_RESOURCE_EXTNS RD
,    FND_USER FND1
,       AMV_C_CHANNELS_B CHN
where RD.USER_ID = FND1.USER_ID
and   RD.RESOURCE_ID = CHN.DEFAULT_APPROVER_USER_ID
and   CHN.CHANNEL_ID = chn_id;

Line: 532

select  	fu.user_name
from		amv_u_access acc
,		fnd_user fu
where	acc.access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
and		acc.access_to_table_record_id = GetApprover.channel_id
and		acc.user_or_group_type = AMV_UTILITY_PVT.G_USER
and		acc.user_or_group_id = fu.user_id;

Line: 593

PROCEDURE Select_Approver ( 	itemtype	in varchar2,
				itemkey  	in varchar2,
				actid		in number,
				funcmode	in varchar2,
				resultout	OUT NOCOPY  varchar2	) IS
--
l_channel_id		number;

Line: 760

			'Selector_Approver',
			itemtype, itemkey,to_char(actid),funcmode);

Line: 763

END Select_Approver;

Line: 796

select  wfl.lookup_code result_code
from    wf_lookups wfl,
	   wf_activities wfa,
	   wf_process_activities wfpa,
	   wf_items wfi
where   wfl.lookup_type         = wfa.result_type
and     wfa.name                = wfpa.activity_name
and     wfi.begin_date          >= wfa.begin_date
and     wfi.begin_date          < nvl(wfa.end_date,wfi.begin_date+1)
and     wfpa.activity_item_type = wfa.item_type
and     wfpa.instance_id        = actid
and     wfi.item_key            = itemkey
and     wfi.item_type           = itemtype;