eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS dependencies on PER_PEOPLE_EXTRA_INFO

Line 1121: FROM per_people_extra_info

1117:
1118: CURSOR csr_per_extra_people_info
1119: IS
1120: SELECT l_column_name
1121: FROM per_people_extra_info
1122: WHERE person_id = p_person_id
1123: AND PEI_INFORMATION_CATEGORY = l_context_name;
1124:
1125: cursor csr_per_start_date is

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

1157: **/
1158: IF l_source_name = 'Extra Person Info DDF' THEN
1159: hr_utility.set_location('into Extra Person Info DDF',1);
1160: sqlstr := 'select ' || l_column_name ||
1161: ' from per_people_extra_info where person_id = :p_person_id and PEI_INFORMATION_CATEGORY = :l_context_name';
1162: hr_utility.set_location(sqlstr,1);
1163: begin
1164: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name;
1165: Exception