APPS.AME_UTILITY_PKG dependencies on AME_APPROVER_TYPES

Line 693: from ame_approver_types appr

689: if l_attribute_type = 'number' and l_approver_type_id is not null then
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'

Line 711: from ame_approver_types appr

707: when others then
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'

Line 735: from ame_approver_types appr

731: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');
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

Line 1455: ame_approver_types apt

1451: end if;
1452:
1453: select count(*) into temp_count
1454: from ame_attributes atr,
1455: ame_approver_types apt
1456: where atr.approver_type_id = apt.approver_type_id
1457: and atr.attribute_id = l_attribute_id
1458: and sysdate between atr.start_date
1459: and nvl(atr.end_date - (1/86400), sysdate)

Line 1559: select ame_approver_types_s.nextval into nextSequence from dual;

1555: nextSequence integer;
1556: countOfIds integer;
1557: begin
1558: while true loop
1559: select ame_approver_types_s.nextval into nextSequence from dual;
1560: select count(*)
1561: into countOfIds
1562: from ame_approver_types
1563: where approver_type_id = nextSequence;

Line 1562: from ame_approver_types

1558: while true loop
1559: select ame_approver_types_s.nextval into nextSequence from dual;
1560: select count(*)
1561: into countOfIds
1562: from ame_approver_types
1563: where approver_type_id = nextSequence;
1564: if countOfIds = 0 then
1565: return nextSequence;
1566: end if;