DBA Data[Home] [Help]

APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_CUST_ACCOUNTS

Line 378: FROM APPS.hz_cust_accounts

374:
375: FUNCTION den_acc_number (party_id NUMBER) RETURN VARCHAR2 IS
376: CURSOR all_account_number (p_party_id NUMBER) IS
377: SELECT ACCOUNT_NUMBER
378: FROM APPS.hz_cust_accounts
379: WHERE PARTY_ID = p_party_id
380: ORDER BY STATUS,CREATION_DATE;
381:
382: l_acct_number VARCHAR2(30);