APPS.PA_CONTROL_ITEMS_PUB dependencies on HZ_PARTIES

Line 21: FROM hz_parties hzp,

17: x_return_status := 'S';
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

Line 165: --get hz_parties.party_id of the logged in user

161: --Clear the global PL/SQL message table
162: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
163: FND_MSG_PUB.initialize;
164: END IF;
165: --get hz_parties.party_id of the logged in user
166: l_last_modified_by_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );
167: l_owner_id := p_owner_id;
168: l_object_id := p_object_id;
169:

Line 431: --get hz_parties.party_id of the logged in user

427: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: --get hz_parties.party_id of the logged in user
432: l_last_modified_by_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );
433: l_owner_id := p_owner_id;
434: l_object_id := p_object_id;
435: