DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on HZ_CUST_ACCOUNTS

Line 488: ,HZ_CUST_ACCOUNTS hzc

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

Line 504: from HZ_CUST_ACCOUNTS hzc

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

Line 543: from HZ_CUST_ACCOUNTS hzc

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