DBA Data[Home] [Help]

APPS.JL_ZZ_AR_UPLOAD_TAXES dependencies on HZ_CUST_SITE_USES

Line 48: HZ_CUST_SITE_USES HZSU

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
52: AND HZAS.CUST_ACCT_SITE_ID = HZSU.CUST_ACCT_SITE_ID

Line 219: HZ_CUST_SITE_USES HZSU

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
223: AND HZAS.CUST_ACCT_SITE_ID = HZSU.CUST_ACCT_SITE_ID

Line 403: FROM HZ_CUST_SITE_USES

399:
400: BEGIN
401: SELECT OBJECT_VERSION_NUMBER
402: INTO l_obj_version
403: FROM HZ_CUST_SITE_USES
404: WHERE SITE_USE_ID = l_site_use_id;
405: EXCEPTION
406: WHEN OTHERS THEN
407: l_obj_version := NULL;