DBA Data[Home] [Help]

APPS.AME_UTILITY_PKG dependencies on WF_ROLES

Line 397: from wf_roles wfroles

393: l_return_value := 'N';
394:
395: if l_name = ame_util.substitutionTypeName or l_name = ame_util.positionTypeName then
396: select 'Y' into l_return_value
397: from wf_roles wfroles
398: ,ame_actions act
399: where wfroles.name = act.parameter
400: and wfroles.status = 'ACTIVE'
401: and (wfroles.expiration_date is null or

Line 695: ,wf_roles wfroles

691: select lookup.meaning ||': '||wfroles.display_name
692: into l_string_value
693: from ame_approver_types appr
694: ,fnd_lookups lookup
695: ,wf_roles wfroles
696: where appr.approver_type_id = l_approver_type_id
697: and lookup.lookup_type = 'FND_WF_ORIG_SYSTEMS'
698: and lookup.lookup_code = appr.orig_system
699: and p_effective_date between appr.start_date