DBA Data[Home] [Help]

APPS.XLA_TB_AP_REPORT_PVT dependencies on HZ_PARTIES

Line 867: ,hz_parties hzp

863: --
864: -- Replace $party_tab$ in C_INSERT_GT_SELECT
865: --
866: C_PARTY_CUST_TABLE CONSTANT VARCHAR2(32000) := '
867: ,hz_parties hzp
868: ,hz_party_sites hps
869: ,hz_cust_accounts hca
870: ,hz_cust_acct_sites_all hcas
871: ,hz_cust_site_uses_all hcsu

Line 902: ,hz_parties hzp

898:
899: C_PARTY_SUPP_TABLE CONSTANT VARCHAR2(32000) := '
900: ,ap_suppliers aps
901: ,ap_supplier_sites_all apss
902: ,hz_parties hzp
903: ,hz_party_sites hps
904: ';
905:
906: --

Line 2013: FROM hz_parties hzp

2009: END IF;
2010:
2011: SELECT hzp.party_name
2012: INTO p_third_party_name
2013: FROM hz_parties hzp
2014: ,hz_cust_accounts hca
2015: WHERE hzp.party_id = hca.party_id
2016: AND hca.cust_account_id = l_party_id;
2017: