APPS.PA_PROJECT_SET_UTILS dependencies on HZ_PARTIES

Line 38: FROM per_all_people_f pap, hz_parties hp

34:
35: IF l_employee_id IS NOT NULL THEN
36: SELECT hp.party_id, hp.party_name
37: INTO x_party_id, x_party_name
38: FROM per_all_people_f pap, hz_parties hp
39: WHERE pap.person_id = l_employee_id
40: AND pap.party_id = hp.party_id
41: AND rownum = 1;
42:

Line 46: FROM hz_parties

42:
43: ELSIF l_customer_id IS NOT NULL THEN
44: SELECT party_id, party_name
45: INTO x_party_id, x_party_name
46: FROM hz_parties
47: WHERE party_type = 'PERSON'
48: AND party_id = l_customer_id
49: AND rownum = 1;
50:

Line 153: l_party_id HZ_PARTIES.party_id%TYPE;

149: p_resp_id NUMBER)
150: RETURN VARCHAR2
151: IS
152: l_update_sup_user VARCHAR2(1);
153: l_party_id HZ_PARTIES.party_id%TYPE;
154: l_party_name HZ_PARTIES.party_name%TYPE;
155: BEGIN
156:
157: l_update_sup_user := PA_SECURITY_PVT.check_user_privilege(

Line 154: l_party_name HZ_PARTIES.party_name%TYPE;

150: RETURN VARCHAR2
151: IS
152: l_update_sup_user VARCHAR2(1);
153: l_party_id HZ_PARTIES.party_id%TYPE;
154: l_party_name HZ_PARTIES.party_name%TYPE;
155: BEGIN
156:
157: l_update_sup_user := PA_SECURITY_PVT.check_user_privilege(
158: p_privilege => 'PA_PROJ_SET_UPDATE'

Line 355: FROM hz_parties

351: IF p_party_id IS NOT NULL THEN
352: IF p_check_id_flag = 'Y' THEN
353: SELECT party_id
354: INTO x_party_id
355: FROM hz_parties
356: WHERE party_id = p_party_id;
357: ELSE
358: x_party_id := p_party_id;
359: END IF;

Line 363: FROM hz_parties

359: END IF;
360: ELSE
361: SELECT party_id
362: INTO x_party_id
363: FROM hz_parties
364: WHERE party_name = p_party_name;
365: END IF;
366:
367: EXCEPTION

Line 485: FROM hz_parties

481: FUNCTION is_party_internal (p_party_id IN NUMBER) RETURN VARCHAR2
482: IS
483: CURSOR c1 IS
484: SELECT orig_system_reference
485: FROM hz_parties
486: WHERE party_id = p_party_id;
487: v_c1 c1%ROWTYPE;
488:
489: BEGIN