APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 1421: FROM per_people_extra_info

1417:
1418: CURSOR csr_per_extra_people_info
1419: IS
1420: SELECT l_column_name
1421: FROM per_people_extra_info
1422: WHERE person_id = p_person_id
1423: AND PEI_INFORMATION_CATEGORY = l_context_name;
1424:
1425: cursor csr_per_start_date is

Line 1461: ' from per_people_extra_info where person_id = :p_person_id and PEI_INFORMATION_CATEGORY = :l_context_name';

1457: **/
1458: IF l_source_name = 'Extra Person Info DDF' THEN
1459: hr_utility.set_location('into Extra Person Info DDF',1);
1460: sqlstr := 'select ' || l_column_name ||
1461: ' from per_people_extra_info where person_id = :p_person_id and PEI_INFORMATION_CATEGORY = :l_context_name';
1462: hr_utility.set_location(sqlstr,1);
1463: begin
1464: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name;
1465: Exception