APPS.AME_GPI_INS dependencies on AME_APPROVAL_GROUPS
Line 508: from ame_approval_groups
504: --
505: Cursor C_Sel1 is
506: select
507: null 508: from ame_approval_groups 509: where approval_group_id = p_rec.approval_group_id
510: and p_effective_date
511: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
512: for update nowait;