DBA Data[Home] [Help]

APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on AME_APPROVAL_GROUP_CONFIG

Line 331: from AME_APPROVAL_GROUP_CONFIG

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

Line 338: insert into AME_APPROVAL_GROUP_CONFIG(

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