APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_CUST_ACCT_SITES

Line 121: ELSIF(p_parent_table_name = 'HZ_CUST_ACCT_SITES_ALL') 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;
124: RETURN NULL;
125: END get_parent_object_type;

Line 328: FROM HZ_CUST_ACCT_SITES

324: WHERE cust_account_id = l_ca_id;
325:
326: CURSOR is_cas_valid(l_cas_id NUMBER, l_org_id NUMBER) IS
327: SELECT 'X'
328: FROM HZ_CUST_ACCT_SITES
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'

Line 388: ELSIF(p_obj_type = 'HZ_CUST_ACCT_SITES_ALL') THEN

384: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNTS') THEN
385: OPEN is_ca_valid(px_id);
386: FETCH is_ca_valid INTO l_valid_id;
387: CLOSE is_ca_valid;
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