DBA Data[Home] [Help]

APPS.AME_ACTIONS_API dependencies on AME_APPROVAL_GROUPS

Line 55: from AME_APPROVAL_GROUPS

51: (
52: X_APPROVAL_GROUP_NAME in VARCHAR2
53: ) is
54: select APPROVAL_GROUP_ID
55: from AME_APPROVAL_GROUPS
56: where NAME = X_APPROVAL_GROUP_NAME
57: and sysdate between START_DATE
58: and nvl(end_date - (1/86400), sysdate);
59: L_PARAMETER NUMBER;

Line 515: from ame_approval_groups

511: ,ame_util.postApprovalTypeName) then
512: begin
513: select approval_group_id
514: into X_APPROVAL_GROUP_ID
515: from ame_approval_groups
516: where name = X_PARAMETER
517: and sysdate between start_date and nvl(end_date, sysdate);
518: X_TEMP_PARAMETER := to_char(X_APPROVAL_GROUP_ID);
519: exception