DBA Data[Home] [Help]

APPS.AME_ACTION_API dependencies on AME_ATTRIBUTE_USAGES

Line 937: from ame_attribute_usages atu

933: where axu.action_type_id = p_action_type_id
934: and sysdate between axu.start_date
935: and nvl(axu.end_date - (1/86400), sysdate)
936: and not exists(select null
937: from ame_attribute_usages atu
938: where atu.attribute_id = p_attribute_id
939: and atu.application_id = axu.application_id
940: and sysdate between atu.start_date and
941: nvl(atu.end_date - (1/86400), sysdate)

Line 954: l_query_string ame_attribute_usages.query_string%TYPE;

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);
958: --