DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on HZ_CUST_ACCT_SITES

Line 631: ,hz_cust_acct_sites ad

627: AND cp_trx_date >= NVL(loc.start_date_active, cp_trx_date)
628: AND exists
629: (select /*+ FIRST_ROWS(1) leading (su) */ 1
630: from hz_cust_site_uses su
631: ,hz_cust_acct_sites ad
632: ,hz_party_sites p
633: ,hz_locations lc
634: ,hz_geographies lv
635: ,ar_system_parameters sp

Line 660: ,hz_cust_acct_sites ad

656: AND p_trx_date <= exc.end_date_active
657: AND p_trx_date >= NVL(exc.start_date_active, p_trx_date)
658: AND exists (select 1
659: from hz_geographies lv
660: ,hz_cust_acct_sites ad
661: ,hz_cust_site_uses su
662: ,hz_party_sites p
663: ,hz_locations loc
664: ,ar_system_parameters sp

Line 691: ,hz_cust_acct_sites ad

687: AND p_trx_date <= exi.end_date_active
688: AND p_trx_date >= NVL(exi.start_date_active, p_trx_date)
689: AND exists (select 1
690: from hz_geographies lv
691: ,hz_cust_acct_sites ad
692: ,hz_cust_site_uses su
693: ,hz_party_sites p
694: ,hz_locations loc
695: ,ar_system_parameters sp