APPS.CE_VALIDATE_BANKINFO_UPG dependencies on HZ_PARTIES

Line 234: FROM CE_UPG_BANK_REC --HZ_PARTIES

230:
231:
232: CURSOR CHECK_UNIQUE_TAXID_BK IS -- Banks
233: SELECT JGZZ_FISCAL_CODE
234: FROM CE_UPG_BANK_REC --HZ_PARTIES
235: WHERE JGZZ_FISCAL_CODE = p_taxpayer_id
236: AND country = p_country_code;
237:
238: l_taxid VARCHAR2(30);

Line 307: FROM HZ_PARTIES AR

303: AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
304:
305: CURSOR CHECK_CROSS_AR IS --Customers
306: SELECT AR.PARTY_NAME, AR.JGZZ_FISCAL_CODE
307: FROM HZ_PARTIES AR
308: WHERE (AR.PARTY_NAME=p_entity_name
309: OR AR.JGZZ_FISCAL_CODE= p_taxpayer_id)
310: AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
311: