APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_PARTIES

Line 23: and child_entity_name = 'HZ_PARTIES'

19: SELECT 'Y'
20: FROM HZ_BUS_OBJ_TRACKING
21: WHERE parent_bo_code is null
22: and event_id = p_event_id
23: and child_entity_name = 'HZ_PARTIES'
24: and child_id = nvl(p_party_id, child_id)
25: and child_bo_code = p_bo_code
26: and nvl(parent_event_flag, p_event_type) = p_event_type
27: and rownum = 1;

Line 66: from hz_parties

62: l_party_type varchar2(30) := null;
63:
64: cursor c1 is
65: select party_type
66: from hz_parties
67: where party_id = p_parent_id;
68:
69: cursor c2 is
70: select party_type

Line 71: from hz_parties p, hz_cust_accounts ca

67: where party_id = p_parent_id;
68:
69: cursor c2 is
70: select party_type
71: from hz_parties p, hz_cust_accounts ca
72: where p.party_id = ca.party_id
73: and ca.cust_account_id = p_parent_id;
74:
75: cursor c_cp is

Line 81: if p_parent_table_name = 'HZ_PARTIES'

77: from HZ_CONTACT_POINTS
78: where contact_point_id = p_parent_id;
79:
80: BEGIN
81: if p_parent_table_name = 'HZ_PARTIES'
82: then
83: open c1;
84: fetch c1 into l_party_type;
85: close c1;

Line 101: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN

97:
98: -- Base on owner_table_name to return HZ_BUSINESS_OBJECTS lookup code
99: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN
100: RETURN 'PARTY_SITE';
101: ELSIF(p_parent_table_name = 'HZ_PARTIES') THEN
102: IF(l_party_type = 'ORGANIZATION') THEN
103: RETURN 'ORG';
104: ELSIF(l_party_type = 'PERSON') THEN
105: RETURN 'PERSON';

Line 163: and child_entity_name = 'HZ_PARTIES';

159: SELECT child_id
160: FROM HZ_BUS_OBJ_TRACKING
161: WHERE parent_bo_code is null
162: and event_id = p_event_id
163: and child_entity_name = 'HZ_PARTIES';
164:
165: begin
166: -- initialize API return status to success.
167: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 305: FROM HZ_PARTIES

301: WHERE org_contact_id = l_oc_id;
302:
303: CURSOR is_pty_valid(l_pty_id NUMBER, l_pty_type VARCHAR2) IS
304: SELECT 'X'
305: FROM HZ_PARTIES
306: WHERE party_id = l_pty_id
307: AND party_type = l_pty_type
308: AND status in ('A', 'I');
309:

Line 409: l_obj_type := 'HZ_PARTIES';

405: IF(l_ss_flag = 'Y')THEN
406: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
407: l_obj_type := 'HZ_CONTACT_POINTS';
408: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN
409: l_obj_type := 'HZ_PARTIES';
410: ELSE
411: l_obj_type := p_obj_type;
412: END IF;
413: