APPS.PA_CONTROL_ITEMS_PUB dependencies on PER_ALL_PEOPLE_F

Line 49: per_all_people_f ppf

45: IF (x_return_status = 'S' AND l_party_id is NULL) THEN
46: SELECT DISTINCT ppf.party_id party_id
47: INTO l_party_id
48: FROM pa_project_parties ppp,
49: per_all_people_f ppf
50: WHERE ppf.full_name = p_name
51: AND (TRUNC(SYSDATE) BETWEEN TRUNC(ppf.effective_start_date)
52: AND TRUNC(ppf.effective_end_date))
53: AND ppp.resource_source_id = ppf.person_id