DBA Data[Home] [Help]

APPS.AMV_WFAPPROVAL_PVT dependencies on AMV_C_CHANNELS_B

Line 191: from amv_c_channels_b

187: --
188: CURSOR Chan_Approvers IS
189: select default_approver_user_id
190: , owner_user_id
191: from amv_c_channels_b
192: where channel_id = channel_id;
193:
194: CURSOR Sec_Approvers IS
195: select chl_approver_flag

Line 294: from amv_c_channels_b

290: and user_or_group_id = l_requestor_id;
291:
292: CURSOR Chn_Publish IS
293: select pub_need_approval_flag
294: from amv_c_channels_b
295: where channel_id = l_channel_id;
296:
297: BEGIN
298: --

Line 424: from amv_c_channels_b

420: and user_or_group_id = l_requestor_id;
421:
422: CURSOR Chn_Subscribe IS
423: select sub_need_approval_flag
424: from amv_c_channels_b
425: where channel_id = l_channel_id;
426:
427: BEGIN
428: --

Line 526: , AMV_C_CHANNELS_B CHN

522: CURSOR Chan_Approvers(chn_id NUMBER) IS
523: select FND1.USER_NAME
524: from JTF_RS_RESOURCE_EXTNS RD
525: , FND_USER FND1
526: , AMV_C_CHANNELS_B CHN
527: where RD.USER_ID = FND1.USER_ID
528: and RD.RESOURCE_ID = CHN.DEFAULT_APPROVER_USER_ID
529: and CHN.CHANNEL_ID = chn_id;
530: