APPS.BEN_EXTRACT_SEED dependencies on PER_ALL_PEOPLE_F

Line 367: ||' '||employee_number from per_all_people_f

363: and nvl(date_to,trunc(sysdate))
364: and tax_unit_id = p_val;
365:
366: cursor c7 is SELECT full_name||' '||national_identifier
367: ||' '||employee_number from per_all_people_f
368: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
369: = nvl(p_business_group_id,-1)
370: and trunc(sysdate)
371: between nvl(effective_start_date,trunc(sysdate))

Line 1132: from per_all_people_f

1128: and nvl(date_to,trunc(sysdate))
1129: and name = p_meaning ;
1130:
1131: cursor c7 is SELECT person_id
1132: from per_all_people_f
1133: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
1134: = nvl(p_business_group_id,-1)
1135: and trunc(sysdate)
1136: between nvl(effective_start_date,trunc(sysdate))