DBA Data[Home] [Help]

APPS.AME_ACTION_USAGES_API2 dependencies on AME_APPROVAL_GROUPS

Line 78: from AME_APPROVAL_GROUPS AAG

74: ,'approval-group chain of authority') then
75: begin
76: select AAG.APPROVAL_GROUP_ID
77: into L_APPROVAL_GROUP_ID
78: from AME_APPROVAL_GROUPS AAG
79: where AAG.NAME = X_PARAMETER
80: and sysdate between AAG.START_DATE and nvl(AAG.END_DATE - (1/86400),sysdate);
81: X_PARAMETER := to_char(L_APPROVAL_GROUP_ID);
82: X_PARAMETER_TWO := null;

Line 406: AME_APPROVAL_GROUPS AAG

402: from AME_ACTIONS ACT,
403: AME_ACTION_TYPES AAT,
404: AME_RULES ARU,
405: AME_ACTION_USAGES AAU,
406: AME_APPROVAL_GROUPS AAG
407: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
408: and ACT.ACTION_ID = AAU.ACTION_ID
409: and AAU.RULE_ID = ARU.RULE_ID
410: and ACT.PARAMETER = to_char(AAG.APPROVAL_GROUP_ID)