APPS.CSI_SYSTEMS_PVT dependencies on HZ_CUST_ACCOUNTS

Line 3517: from HZ_CUST_ACCOUNTS

3513: (nvl(p_system_rec.CASCADE_CUST_TO_INS_FLAG,'N') = 'Y') ) THEN
3514: Begin
3515: select party_id
3516: into l_party_id
3517: from HZ_CUST_ACCOUNTS
3518: where cust_account_id = p_system_rec.customer_id;
3519: Exception
3520: when others then
3521: null;

Line 4492: FROM hz_cust_accounts hzc

4488: THEN
4489: BEGIN
4490: SELECT 'x'
4491: INTO l_dummy
4492: FROM hz_cust_accounts hzc
4493: ,hz_parties hz
4494: WHERE hzc.cust_account_id = p_customer_id
4495: AND hzc.party_id=hz.party_id;
4496:

Line 4522: FROM hz_cust_accounts hzc

4518: THEN
4519: BEGIN
4520: SELECT 'x'
4521: INTO l_dummy
4522: FROM hz_cust_accounts hzc
4523: ,hz_parties hz
4524: WHERE hzc.cust_account_id = p_customer_id
4525: AND hzc.party_id=hz.party_id;
4526:

Line 5833: FROM HZ_CUST_ACCOUNTS hza

5829: ,p_system_header_tbl(sys_row).customer_name
5830: ,p_system_header_tbl(sys_row).party_id
5831: ,p_system_header_tbl(sys_row).customer_party_number
5832: ,p_system_header_tbl(sys_row).party_name
5833: FROM HZ_CUST_ACCOUNTS hza
5834: ,HZ_PARTIES hzp
5835: WHERE hza.cust_account_id = p_system_header_tbl(sys_row).customer_id
5836: AND hza.party_id = hzp.party_id;
5837: EXCEPTION