327:
328: BEGIN
329:
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
2023:
2024: BEGIN
2025:
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