APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 119: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNT_ROLES') THEN

115: RETURN 'PERSON_CUST';
116: ELSIF(l_party_type IS NULL) THEN
117: RETURN 'CUST_ACCT';
118: END IF;
119: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNT_ROLES') THEN
120: RETURN 'CUST_ACCT_CONTACT';
121: ELSIF(p_parent_table_name = 'HZ_CUST_ACCT_SITES_ALL') THEN
122: RETURN 'CUST_ACCT_SITE';
123: END IF;

Line 322: FROM HZ_CUST_ACCOUNT_ROLES

318: WHERE location_id = l_loc_id;
319:
320: CURSOR is_cr_valid(l_cr_id NUMBER) IS
321: SELECT 'X'
322: FROM HZ_CUST_ACCOUNT_ROLES
323: WHERE cust_account_role_id = l_cr_id;
324:
325: CURSOR is_ca_valid(l_ca_id NUMBER) IS
326: SELECT 'X'

Line 376: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNT_ROLES') THEN

372: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN
373: OPEN is_pty_valid(px_id, p_obj_type);
374: FETCH is_pty_valid INTO l_valid_id;
375: CLOSE is_pty_valid;
376: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
377: OPEN is_cr_valid(px_id);
378: FETCH is_cr_valid INTO l_valid_id;
379: CLOSE is_cr_valid;
380: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN