DBA Data[Home] [Help]

APPS.EAM_OTL_TIMECARD_PUB dependencies on PER_ALL_PEOPLE_F

Line 398: --fix for 3823899.use table per_all_people_f and check effectivity dates

394: begin
395:
396: if (p_instance_id is not null) then
397:
398: --fix for 3823899.use table per_all_people_f and check effectivity dates
399: --Fix for 6808173. Modified check for effectivity dates. It was causing errors for name changes made in HR.
400:
401: select distinct full_name
402: into l_employee_name

Line 403: from PER_ALL_PEOPLE_F

399: --Fix for 6808173. Modified check for effectivity dates. It was causing errors for name changes made in HR.
400:
401: select distinct full_name
402: into l_employee_name
403: from PER_ALL_PEOPLE_F
404: where person_id = p_instance_id
405: and l_start_time BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
406: --and NVL(current_employee_flag,'N')='Y';
407: