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.BEN_EXTRACT_SEED dependencies on PER_ALL_PEOPLE_F

Line 420: ||' '||employee_number from per_all_people_f

416: and nvl(date_to,trunc(sysdate))
417: and tax_unit_id = p_val;
418:
419: cursor c7 is SELECT full_name||' '||national_identifier
420: ||' '||employee_number from per_all_people_f
421: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
422: = nvl(p_business_group_id,-1)
423: and trunc(sysdate)
424: between nvl(effective_start_date,trunc(sysdate))

Line 1185: from per_all_people_f

1181: and nvl(date_to,trunc(sysdate))
1182: and name = p_meaning ;
1183:
1184: cursor c7 is SELECT person_id
1185: from per_all_people_f
1186: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
1187: = nvl(p_business_group_id,-1)
1188: and trunc(sysdate)
1189: between nvl(effective_start_date,trunc(sysdate))