DBA Data[Home] [Help]

APPS.AME_GPI_BUS dependencies on AME_APPROVAL_GROUP_MEMBERS

Line 232: from ame_approval_group_members

228: and sysdate between nvl(start_date,sysdate) and
229: nvl(expiration_date,sysdate);
230: elsif p_parameter_name = 'OAM_group_id' then
231: select count(*) into l_count
232: from ame_approval_group_members
233: where approval_group_id = p_parameter
234: and orig_system not in ('FND_USR','PER');
235: end if;
236: -- If group item has members of approver type other than 'PER' and 'FND_USR'