DBA Data[Home] [Help]

APPS.AME_CALLING_APPS_API dependencies on AME_APPROVAL_GROUPS

Line 473: from ame_approval_groups aag

469: )
470: is
471: cursor getApprovalGroup is
472: select aag.approval_group_id, aag.name, aag.start_date, aag.end_date
473: from ame_approval_groups aag
474: where aag.start_date =
475: (select max(start_date)
476: from ame_approval_groups aag2
477: where aag.approval_group_id = aag2.approval_group_id)

Line 476: from ame_approval_groups aag2

472: select aag.approval_group_id, aag.name, aag.start_date, aag.end_date
473: from ame_approval_groups aag
474: where aag.start_date =
475: (select max(start_date)
476: from ame_approval_groups aag2
477: where aag.approval_group_id = aag2.approval_group_id)
478: order by aag.approval_group_id;
479: cursor getActionType is
480: select aat.action_type_id,