DBA Data[Home] [Help]

APPS.AME_PRODUCTION_ACTIONS_API dependencies on DUAL

Line 47: from dual;

43: X_ACTION_ID number;
44: begin
45: select AME_ACTIONS_S.NEXTVAL
46: into X_ACTION_ID
47: from dual;
48:
49: insert into AME_ACTIONS
50: (ACTION_ID
51: ,ACTION_TYPE_ID

Line 76: from dual

72: X_LAST_UPDATED_BY,
73: X_LAST_UPDATE_DATE,
74: X_LAST_UPDATE_LOGIN,
75: X_OBJECT_VERSION_NUMBER
76: from dual
77: where not exists (select null
78: from AME_ACTIONS
79: where ACTION_TYPE_ID = X_ACTION_TYPE_ID
80: and PARAMETER = X_PARAMETER