DBA Data[Home] [Help]

APPS.JG_TAXID_VAL_PKG dependencies on XLE_REGISTRATIONS_V

Line 391: FROM XLE_REGISTRATIONS_V -- Coud use this view XLE_LE_FROM_REGISTRATIONS_V

387: AND HZP.PARTY_ID = HZC.PARTY_ID;
388:
389: CURSOR CHECK_CROSS_HR IS --Companies
390: SELECT LEGAL_ENTITY_NAME, REGISTRATION_NUMBER
391: FROM XLE_REGISTRATIONS_V -- Coud use this view XLE_LE_FROM_REGISTRATIONS_V
392: WHERE (LEGAL_ENTITY_NAME = p_entity_name
393: OR REGISTRATION_NUMBER = p_taxpayer_id)
394: AND Legislative_Category = 'INCOME_TAX'
395: AND COUNTRY = p_country_code;