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 318: FROM HZ_CUST_ACCOUNT_ROLES

314: WHERE location_id = l_loc_id;
315:
316: CURSOR is_cr_valid(l_cr_id NUMBER) IS
317: SELECT 'X'
318: FROM HZ_CUST_ACCOUNT_ROLES
319: WHERE cust_account_role_id = l_cr_id;
320:
321: CURSOR is_ca_valid(l_ca_id NUMBER) IS
322: SELECT 'X'

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

368: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN
369: OPEN is_pty_valid(px_id, p_obj_type);
370: FETCH is_pty_valid INTO l_valid_id;
371: CLOSE is_pty_valid;
372: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
373: OPEN is_cr_valid(px_id);
374: FETCH is_cr_valid INTO l_valid_id;
375: CLOSE is_cr_valid;
376: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN