APPS.JL_ZZ_AR_UPLOAD_TAXES dependencies on HZ_PARTIES

Line 38: FROM HZ_PARTIES PARTY,

34: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
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:

Line 45: FROM HZ_PARTIES HZP,

41: AND PARTY.JGZZ_FISCAL_CODE = To_Char(C_TAXPAYER_ID);
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

Line 216: FROM HZ_PARTIES HZP,

212: IF Nvl(l_proper_tax_rate_code,'N') = 'Y' THEN
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)