DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on HZ_CUST_ACCT_SITES

Line 614: ,hz_cust_acct_sites ad

610: AND p_trx_date <= loc.end_date_active
611: AND p_trx_date >= NVL(loc.start_date_active, p_trx_date)
612: AND exists (select 1
613: from hz_geographies lv
614: ,hz_cust_acct_sites ad
615: ,hz_cust_site_uses su
616: ,hz_party_sites p
617: ,hz_locations lc
618: ,ar_system_parameters sp

Line 645: ,hz_cust_acct_sites ad

641: AND p_trx_date <= exc.end_date_active
642: AND p_trx_date >= NVL(exc.start_date_active, p_trx_date)
643: AND exists (select 1
644: from hz_geographies lv
645: ,hz_cust_acct_sites ad
646: ,hz_cust_site_uses su
647: ,hz_party_sites p
648: ,hz_locations loc
649: ,ar_system_parameters sp

Line 676: ,hz_cust_acct_sites ad

672: AND p_trx_date <= exi.end_date_active
673: AND p_trx_date >= NVL(exi.start_date_active, p_trx_date)
674: AND exists (select 1
675: from hz_geographies lv
676: ,hz_cust_acct_sites ad
677: ,hz_cust_site_uses su
678: ,hz_party_sites p
679: ,hz_locations loc
680: ,ar_system_parameters sp