APPS.AME_ACTION_API dependencies on AME_ATTRIBUTES

Line 953: l_attribute_type ame_attributes.attribute_type%TYPE;

949: l_end_date date;
950: l_req_object_version_number number;
951: l_req_start_date date;
952: l_req_end_date date;
953: l_attribute_type ame_attributes.attribute_type%TYPE;
954: l_query_string ame_attribute_usages.query_string%TYPE;
955: --
956: begin
957: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 989: from ame_attributes

985: --now create usage for this required attribute for all
986: --transaction types having config for this action type
987: select attribute_type
988: into l_attribute_type
989: from ame_attributes
990: where attribute_id = p_attribute_id
991: and sysdate between start_date and
992: nvl(end_date - (1/86400), sysdate);
993: l_query_string := null;