APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_CUST_SITE_USES

Line 333: FROM HZ_CUST_SITE_USES

329: WHERE cust_acct_site_id = l_cas_id;
330:
331: CURSOR is_casu_valid(l_casu_id NUMBER, l_org_id NUMBER) IS
332: SELECT 'X'
333: FROM HZ_CUST_SITE_USES
334: WHERE site_use_id = l_casu_id;
335:
336: l_owner_table_id NUMBER;
337: l_ss_flag VARCHAR2(1);

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

388: ELSIF(p_obj_type = 'HZ_CUST_ACCT_SITES_ALL') THEN
389: OPEN is_cas_valid(px_id, p_org_id);
390: FETCH is_cas_valid INTO l_valid_id;
391: CLOSE is_cas_valid;
392: ELSIF(p_obj_type = 'HZ_CUST_SITE_USES_ALL') THEN
393: OPEN is_casu_valid(px_id, p_org_id);
394: FETCH is_casu_valid INTO l_valid_id;
395: CLOSE is_casu_valid;
396: END IF;