DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on HZ_GEOGRAPHIES

Line 634: ,hz_geographies lv

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
636: WHERE su.site_use_id = cp_site_use_id
637: AND ad.cust_acct_site_id = su.cust_acct_site_id
638: AND p.party_site_id = ad.party_site_id

Line 659: from hz_geographies lv

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

Line 690: from hz_geographies lv

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