DBA Data[Home] [Help]

APPS.AME_GPI_BUS dependencies on AME_APPROVAL_GROUP_MEMBERS

Line 226: from ame_approval_group_members

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