APPS.PAY_GB_RTI_NINO_REPLY_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 119: from per_people_extra_info where PERSON_ID = f_person_id

115: l_nino_verified_flag varchar2(15) := null;
116: l_correlation_id varchar2(35);
117: cursor fetch_person_extra_info is
118: select PERSON_EXTRA_INFO_ID,object_version_number,pei_information1, pei_information5
119: from per_people_extra_info where PERSON_ID = f_person_id
120: and pei_information_category = 'RTI_NINO';
121: begin
122: fnd_file.put_line(fnd_file.LOG,'Entering ' ||l_package_name || '.update_extra_information');
123:

Line 126: from per_people_extra_info where PERSON_ID = f_person_id

122: fnd_file.put_line(fnd_file.LOG,'Entering ' ||l_package_name || '.update_extra_information');
123:
124: /*select PERSON_EXTRA_INFO_ID,object_version_number,pei_information1, pei_information5 into
125: l_extra_info_id, l_object_version_number, l_nino_verified_flag,l_correlation_id
126: from per_people_extra_info where PERSON_ID = f_person_id
127: and pei_information_category = 'RTI_NINO';
128: */
129:
130: fnd_file.put_line(fnd_file.LOG, 'f_person_id: ' ||to_char(f_person_id) ||