DBA Data[Home] [Help]

APPS.PAY_GB_PRE_RTI_NINO dependencies on PER_PEOPLE_EXTRA_INFO

Line 26: select PERSON_EXTRA_INFO_ID,object_version_number,pei_information1 from per_people_extra_info where PERSON_ID = f_person_id

22: l_extra_info_id number := null;
23: l_object_version_number number;
24: l_nino_verified_flag varchar2(15) := null;
25: cursor get_emp_extra_info is
26: select PERSON_EXTRA_INFO_ID,object_version_number,pei_information1 from per_people_extra_info where PERSON_ID = f_person_id
27: and pei_information_category = 'RTI_NINO';
28: begin
29: fnd_file.put_line(fnd_file.LOG,'Entering ' ||l_package_name || '.update_extra_information');
30: open get_emp_extra_info;