Line 1338: and lc_date_from between date_from and nvl(date_to,hr_api.g_eot);
1334: from per_addresses pa
1335: where person_id = X_Person_Id
1336: and address_id <> lc_addr_id
1337: and primary_flag = 'Y' 1338: and lc_date_from between date_from and nvl(date_to,hr_api.g_eot); 1339: --
1340: cursor phones is
1341: select phone_id,phone_number,object_version_number
1342: from per_phones