DBA Data[Home] [Help]

APPS.XLA_TB_REPORT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 566: ,hz_cust_accounts hca

562: --
563: C_PARTY_CUST_TABLE CONSTANT VARCHAR2(32000) := '
564: ,hz_parties hzp
565: ,hz_party_sites hps
566: ,hz_cust_accounts hca
567: ,hz_cust_acct_sites_all hcas
568: ,hz_cust_site_uses_all hcsu
569: ';
570:

Line 1835: ,hz_cust_accounts hca

1831:
1832: SELECT hzp.party_name
1833: INTO p_third_party_name
1834: FROM hz_parties hzp
1835: ,hz_cust_accounts hca
1836: WHERE hzp.party_id = hca.party_id
1837: AND hca.cust_account_id = l_party_id;
1838:
1839: ELSIF l_party_type_code = 'S' THEN