DBA Data[Home] [Help]

APPS.PA_RESOURCE_PVT dependencies on PER_ADDRESSES

Line 955: FROM per_addresses

951:
952: CURSOR denormalized_locations (l_person_id IN NUMBER, l_asgn_start_date IN DATE, l_asgn_end_date IN DATE ) IS
953: SELECT date_from,
954: date_to
955: FROM per_addresses
956: WHERE person_id = l_person_id
957: AND date_from <= l_asgn_end_date
958: AND nvl(date_to, l_asgn_end_date) >= l_asgn_start_date
959: AND primary_flag = 'Y'