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