DBA Data[Home] [Help]

APPS.PER_PEOPLE_V7_PKG dependencies on HR_API

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