DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on HZ_CUST_ACCOUNTS

Line 491: ,HZ_CUST_ACCOUNTS hzc

487: Begin
488: select 'x'
489: into l_exists
490: from HZ_PARTIES hzp
491: ,HZ_CUST_ACCOUNTS hzc
492: where hzc.cust_account_id = p_account_rec.party_account_id
493: and hzc.party_id = p_party_id
494: and hzc.party_id = hzp.party_id;
495: Exception

Line 507: from HZ_CUST_ACCOUNTS hzc

503: ELSE
504: Begin
505: select 'x'
506: into l_exists
507: from HZ_CUST_ACCOUNTS hzc
508: where hzc.cust_account_id = p_account_rec.party_account_id;
509: Exception
510: when others then
511: l_return_status := FALSE;

Line 546: from HZ_CUST_ACCOUNTS hzc

542: p_acct_id_tbl(l_ctr).account_id := p_account_rec.party_account_id;
543: Begin
544: select 'x'
545: into l_exists
546: from HZ_CUST_ACCOUNTS hzc
547: where hzc.cust_account_id = p_account_rec.party_account_id;
548: p_acct_id_tbl(l_ctr).valid_flag := 'Y';
549: Exception
550: when others then