APPS.CSI_MASS_EDIT_PUB dependencies on HZ_CUST_ACCOUNTS

Line 2258: hz_cust_accounts account

2254: FROM csi_t_txn_line_details tld,
2255: csi_t_party_details tp,
2256: csi_t_party_accounts ta,
2257: hz_parties party,
2258: hz_cust_accounts account
2259: WHERE tld.txn_line_detail_id = tp.txn_line_detail_id
2260: AND tld.transaction_line_id = p_transaction_line_id
2261: AND tld.INSTANCE_ID IS NULL
2262: AND tp.txn_party_detail_id = ta.txn_party_detail_id

Line 2270: -- FROM HZ_CUST_ACCOUNTS

2266: AND tp.party_source_table = 'HZ_PARTIES';
2267: -- Bug 7350165
2268: -- CURSOR mu_customer_id_csr (p_party_id IN NUMBER, p_account_number IN NUMBER) IS
2269: -- SELECT CUST_ACCOUNT_ID CUSTOMER_ID
2270: -- FROM HZ_CUST_ACCOUNTS
2271: -- WHERE PARTY_ID = p_party_id
2272: -- AND ACCOUNT_NUMBER = p_account_number;
2273:
2274: CURSOR mu_system_csr (p_system_id IN NUMBER) IS

Line 2738: -- FROM HZ_CUST_ACCOUNTS

2734:
2735: -- Bug 7350165
2736: --CURSOR SYS_CUST_CSR (p_party_id IN NUMBER, p_account_number IN NUMBER) IS
2737: -- SELECT CUST_ACCOUNT_ID CUSTOMER_ID
2738: -- FROM HZ_CUST_ACCOUNTS
2739: -- WHERE PARTY_ID = p_party_id
2740: -- AND ACCOUNT_NUMBER = p_account_number;
2741:
2742: -- l_sys_cust_rec SYS_CUST_CSR%ROWTYPE; bug 7350165