APPS.PA_ADVERTISEMENTS_PVT dependencies on PER_PEOPLE_F

Line 746: FROM pa_people_role_on_orgs_v pro, per_people_f pf

742: -- in the given organization
743:
744: CURSOR get_people_with_proj_authority IS
745: SELECT pro.person_name, pro.person_id
746: FROM pa_people_role_on_orgs_v pro, per_people_f pf
747: WHERE pro.organization_id = to_char(p_organization_id)
748: AND pro.project_role_type = '3'
749: AND sysdate between pro.start_date_active and
750: nvl(pro.end_date_active, sysdate)

Line 1027: per_people_f per

1023: -- Start of Performance Fix 4898314 SQL ID 14906391
1024: CURSOR get_person_on_project_role IS
1025: SELECT per.person_id resource_source_id, per.full_name resource_name
1026: FROM pa_project_parties pp,
1027: per_people_f per
1028: WHERE pp.project_id = p_project_id
1029: AND pp.project_role_id = p_project_role_id
1030: AND pp.resource_source_id = per.person_id
1031: AND (per.employee_number IS NOT NULL OR per.npw_number IS NOT NULL)

Line 1047: FROM per_people_f per

1043:
1044: -- Start of Performance Fix 4898314 SQL ID 14906422
1045: CURSOR get_person_name IS
1046: SELECT per.person_id resource_source_id, per.full_name resource_name
1047: FROM per_people_f per
1048: WHERE per.person_id = p_person_id
1049: AND (per.employee_number IS NOT NULL OR per.npw_number IS NOT NULL)
1050: AND (per.current_employee_flag = 'Y' OR per.current_npw_flag = 'Y')
1051: AND trunc(sysdate) BETWEEN per.effective_start_date