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 180: --get hz_parties.party_id of the logged in user

176: --Clear the global PL/SQL message table
177: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
178: FND_MSG_PUB.initialize;
179: END IF;
180: --get hz_parties.party_id of the logged in user
181: -- l_last_modified_by_id := nvl(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id);
182: -- 26-Jun-2009 cklee Modified for the Bug# 8633676
183: l_owner_id := p_owner_id;
184: l_object_id := p_object_id;

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

470: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
471: FND_MSG_PUB.initialize;
472: END IF;
473:
474: --get hz_parties.party_id of the logged in user
475: -- l_last_modified_by_id := nvl(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id);
476: --26-Jun-2009 cklee Modified for the Bug# 8633676
477: l_owner_id := p_owner_id;
478: l_object_id := p_object_id;