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 427: from hz_cust_accounts a, hz_parties b

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