DBA Data[Home] [Help]

APPS.AME_UTILITY_PKG dependencies on FND_LOOKUPS

Line 694: ,fnd_lookups lookup

690: begin
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

Line 712: ,fnd_lookups lookup

708: begin
709: select lookup.meaning ||': '||wfroles.display_name
710: into l_string_value
711: from ame_approver_types appr
712: ,fnd_lookups lookup
713: ,wf_local_roles wfroles
714: where appr.approver_type_id = l_approver_type_id
715: and lookup.lookup_type = 'FND_WF_ORIG_SYSTEMS'
716: and lookup.lookup_code = appr.orig_system

Line 736: ,fnd_lookups lookup

732: fnd_message.set_token('ATTR',l_attribute_name);
733: select lookup.meaning ||': '|| l_parameter_one
734: into l_string_value
735: from ame_approver_types appr
736: ,fnd_lookups lookup
737: where appr.approver_type_id = l_approver_type_id
738: and lookup.lookup_type = 'FND_WF_ORIG_SYSTEMS'
739: and lookup.lookup_code = appr.orig_system
740: and p_effective_date between appr.start_date