APPS.PA_CONTROL_ITEMS_PUB dependencies on PA_PROJECT_PARTIES

Line 22: pa_project_parties ppp

18: BEGIN
19: SELECT DISTINCT ppp.resource_source_id party_id
20: INTO l_party_id
21: FROM hz_parties hzp,
22: pa_project_parties ppp
23: WHERE hzp.party_name = p_name
24: AND hzp.party_type = 'PERSON'
25: AND ppp.resource_source_id = hzp.party_id
26: AND ppp.resource_type_id = 112

Line 48: FROM pa_project_parties ppp,

44:
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))