DBA Data[Home] [Help]

APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on AME_APPROVAL_GROUP_CONFIG

Line 333: from AME_APPROVAL_GROUP_CONFIG

329: -- Obtain the maximum order number allotted for that application_id.
330: --
331: select nvl(max(order_number),0)+1
332: into L_ORDER_NUMBER
333: from AME_APPROVAL_GROUP_CONFIG
334: where application_id = APPLICATION_ID_LIST(indx)
335: and sysdate between start_date
336: and nvl(end_date - ame_util.oneSecond,sysdate);
337: --

Line 340: insert into AME_APPROVAL_GROUP_CONFIG(

336: and nvl(end_date - ame_util.oneSecond,sysdate);
337: --
338: -- Now insert a row for each application_id.
339: --
340: insert into AME_APPROVAL_GROUP_CONFIG(
341: APPLICATION_ID
342: ,APPROVAL_GROUP_ID
343: ,VOTING_REGIME
344: ,ORDER_NUMBER