APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_CUST_SITE_USES

Line 337: FROM HZ_CUST_SITE_USES

333: WHERE cust_acct_site_id = l_cas_id;
334:
335: CURSOR is_casu_valid(l_casu_id NUMBER, l_org_id NUMBER) IS
336: SELECT 'X'
337: FROM HZ_CUST_SITE_USES
338: WHERE site_use_id = l_casu_id;
339:
340: l_owner_table_id NUMBER;
341: l_ss_flag VARCHAR2(1);

Line 396: ELSIF(p_obj_type = 'HZ_CUST_SITE_USES_ALL') THEN

392: ELSIF(p_obj_type = 'HZ_CUST_ACCT_SITES_ALL') THEN
393: OPEN is_cas_valid(px_id, p_org_id);
394: FETCH is_cas_valid INTO l_valid_id;
395: CLOSE is_cas_valid;
396: ELSIF(p_obj_type = 'HZ_CUST_SITE_USES_ALL') THEN
397: OPEN is_casu_valid(px_id, p_org_id);
398: FETCH is_casu_valid INTO l_valid_id;
399: CLOSE is_casu_valid;
400: END IF;