APPS.PAY_GB_RTI_EYU dependencies on PER_PEOPLE_EXTRA_INFO

Line 313: FROM per_people_extra_info

309:
310: CURSOR csr_per_extra_people_info
311: IS
312: SELECT l_column_name
313: FROM per_people_extra_info
314: WHERE person_id = p_person_id
315: AND PEI_INFORMATION_CATEGORY = l_context_name;
316:
317: cursor csr_per_start_date is

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

349: **/
350: IF l_source_name = 'Extra Person Info DDF' THEN
351: hr_utility.set_location('into Extra Person Info DDF',1);
352: sqlstr := 'select ' || l_column_name ||
353: ' from per_people_extra_info where person_id = :p_person_id and PEI_INFORMATION_CATEGORY = :l_context_name';
354: hr_utility.set_location(sqlstr,1);
355: begin
356: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name;
357: Exception