APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_CUST_ACCOUNTS

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 91: elsif p_parent_table_name = 'HZ_CUST_ACCOUNTS'

87: then
88: open c_cp;
89: fetch c_cp into l_party_type;
90: close c_cp;
91: elsif p_parent_table_name = 'HZ_CUST_ACCOUNTS'
92: then
93: open c2;
94: fetch c2 into l_party_type;
95: close c2;

Line 111: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNTS') THEN

107: RETURN 'ORG_CONTACT';
108: END IF;
109: ELSIF(p_parent_table_name = 'HZ_CONTACT_POINTS') THEN
110: RETURN l_party_type;
111: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNTS') THEN
112: IF(l_party_type = 'ORGANIZATION') THEN
113: RETURN 'ORG_CUST';
114: ELSIF(l_party_type = 'PERSON') THEN
115: RETURN 'PERSON_CUST';

Line 323: FROM HZ_CUST_ACCOUNTS

319: WHERE cust_account_role_id = l_cr_id;
320:
321: CURSOR is_ca_valid(l_ca_id NUMBER) IS
322: SELECT 'X'
323: FROM HZ_CUST_ACCOUNTS
324: WHERE cust_account_id = l_ca_id;
325:
326: CURSOR is_cas_valid(l_cas_id NUMBER, l_org_id NUMBER) IS
327: SELECT 'X'

Line 384: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNTS') THEN

380: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN
381: OPEN is_ps_valid(px_id);
382: FETCH is_ps_valid INTO l_valid_id;
383: CLOSE is_ps_valid;
384: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNTS') THEN
385: OPEN is_ca_valid(px_id);
386: FETCH is_ca_valid INTO l_valid_id;
387: CLOSE is_ca_valid;
388: ELSIF(p_obj_type = 'HZ_CUST_ACCT_SITES_ALL') THEN