APPS.HZ_COMMON_PUB dependencies on HZ_CUST_ACCOUNTS

Line 271: FROM hz_cust_accounts

267: WHILE l_count > 0 LOOP
268: SELECT to_char(hz_account_num_s.nextval)
269: INTO l_account_number FROM dual;
270: SELECT COUNT(*) INTO l_count
271: FROM hz_cust_accounts
272: WHERE account_number = l_account_number;
273:
274: END LOOP;
275: RETURN l_account_number;

Line 429: from hz_cust_accounts a, hz_parties b

425: v_return hz_parties.party_name%type;
426:
427: cursor c is
428: select b.party_name
429: from hz_cust_accounts a, hz_parties b
430: where a.cust_account_id = v_cust_id
431: and a.party_id = b.party_id;
432:
433: begin