APPS.JL_ZZ_AR_UPLOAD_TAXES dependencies on HZ_CUST_ACCOUNTS

Line 39: HZ_CUST_ACCOUNTS CUST

35:
36: CURSOR FIND_CT_FOR_TAXPAYER(C_TAXPAYER_ID NUMBER) IS
37: SELECT CUST.CUST_ACCOUNT_ID
38: FROM HZ_PARTIES PARTY,
39: HZ_CUST_ACCOUNTS CUST
40: WHERE CUST.PARTY_ID = PARTY.PARTY_ID
41: AND PARTY.JGZZ_FISCAL_CODE = To_Char(C_TAXPAYER_ID);
42:
43: CURSOR GET_SITES_FOR_CT(C_CUSTOMER_ID NUMBER) IS

Line 46: HZ_CUST_ACCOUNTS HZCA,

42:
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

Line 217: HZ_CUST_ACCOUNTS HZCA,

213: BEGIN
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