APPS.JL_ZZ_AR_UPLOAD_TAXES dependencies on HZ_CUST_ACCT_SITES

Line 47: HZ_CUST_ACCT_SITES HZAS,

43: CURSOR GET_SITES_FOR_CT(C_CUSTOMER_ID NUMBER) IS
44: SELECT HZSU.SITE_USE_ID
45: FROM HZ_PARTIES HZP,
46: HZ_CUST_ACCOUNTS HZCA,
47: HZ_CUST_ACCT_SITES HZAS,
48: HZ_CUST_SITE_USES HZSU
49: WHERE HZCA.CUST_ACCOUNT_ID = C_CUSTOMER_ID
50: AND HZCA.PARTY_ID = HZP.PARTY_ID
51: AND HZCA.CUST_ACCOUNT_ID = HZAS.CUST_ACCOUNT_ID

Line 218: HZ_CUST_ACCT_SITES HZAS,

214: SELECT DISTINCT 'Y'
215: INTO l_data_change_flag
216: FROM HZ_PARTIES HZP,
217: HZ_CUST_ACCOUNTS HZCA,
218: HZ_CUST_ACCT_SITES HZAS,
219: HZ_CUST_SITE_USES HZSU
220: WHERE HZP.JGZZ_FISCAL_CODE = To_Char(l_taxpayer_id)
221: AND HZCA.PARTY_ID = HZP.PARTY_ID
222: AND HZCA.CUST_ACCOUNT_ID = HZAS.CUST_ACCOUNT_ID