APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 99: IF(p_parent_table_name = 'HZ_PARTY_SITES') THEN

95: close c2;
96: end if;
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';

Line 308: FROM HZ_PARTY_SITES

304: AND status in ('A', 'I');
305:
306: CURSOR is_ps_valid(l_ps_id NUMBER) IS
307: SELECT 'X'
308: FROM HZ_PARTY_SITES
309: WHERE party_site_id = l_ps_id;
310:
311: CURSOR is_loc_valid(l_loc_id NUMBER) IS
312: SELECT 'X'

Line 380: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN

376: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN
377: OPEN is_loc_valid(px_id);
378: FETCH is_loc_valid INTO l_valid_id;
379: CLOSE is_loc_valid;
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