DBA Data[Home] [Help]

APPS.XLA_TB_AP_REPORT_PVT dependencies on HZ_PARTIES

Line 486: ,hz_parties hzp

482: --
483: -- Replace $party_tab$ in C_INSERT_GT_SELECT
484: --
485: C_PARTY_CUST_TABLE CONSTANT VARCHAR2(32000) := '
486: ,hz_parties hzp
487: ,hz_party_sites hps
488: ,hz_cust_accounts hca
489: ,hz_cust_acct_sites_all hcas
490: ,hz_cust_site_uses_all hcsu

Line 521: ,hz_parties hzp

517:
518: C_PARTY_SUPP_TABLE CONSTANT VARCHAR2(32000) := '
519: ,ap_suppliers aps
520: ,ap_supplier_sites_all apss
521: ,hz_parties hzp
522: ,hz_party_sites hps
523: ';
524:
525: --

Line 1540: FROM hz_parties hzp

1536: END IF;
1537:
1538: SELECT hzp.party_name
1539: INTO p_third_party_name
1540: FROM hz_parties hzp
1541: ,hz_cust_accounts hca
1542: WHERE hzp.party_id = hca.party_id
1543: AND hca.cust_account_id = l_party_id;
1544: