DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on HZ_GEOGRAPHIES

Line 613: from hz_geographies lv

609: WHERE loc.tax_category_id = p_tax_category_id
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

Line 644: from hz_geographies lv

640: AND exc.tax_category_id = p_tax_category_id
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

Line 675: from hz_geographies lv

671: AND exi.tax_category_id = p_tax_category_id
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