DBA Data[Home] [Help]

APPS.JL_AR_APPLICABLE_TAXES dependencies on HZ_CUST_SITE_USES_ALL

Line 334: HZ_CUST_SITE_USES_ALL HZSU

330: SELECT DISTINCT 'Y' INTO l_taxpayer_ar
331: FROM HZ_PARTIES HZP,
332: HZ_CUST_ACCOUNTS_ALL HZCA,
333: HZ_CUST_ACCT_SITES_ALL HZAS,
334: HZ_CUST_SITE_USES_ALL HZSU
335: WHERE HZCA.PARTY_ID = HZP.PARTY_ID
336: AND HZCA.CUST_ACCOUNT_ID = HZAS.CUST_ACCOUNT_ID
337: AND HZAS.CUST_ACCT_SITE_ID = HZSU.CUST_ACCT_SITE_ID
338: AND HZSU.ORG_ID = l_ORG_ID

Line 2030: HZ_CUST_SITE_USES_ALL HZSU

2026: SELECT DISTINCT 'Y' INTO l_taxpayer_ar
2027: FROM HZ_PARTIES HZP,
2028: HZ_CUST_ACCOUNTS_ALL HZCA,
2029: HZ_CUST_ACCT_SITES_ALL HZAS,
2030: HZ_CUST_SITE_USES_ALL HZSU
2031: WHERE HZCA.PARTY_ID = HZP.PARTY_ID
2032: AND HZCA.CUST_ACCOUNT_ID = HZAS.CUST_ACCOUNT_ID
2033: AND HZAS.CUST_ACCT_SITE_ID = HZSU.CUST_ACCT_SITE_ID
2034: AND HZSU.ORG_ID = l_ORG_ID