DBA Data[Home] [Help]

APPS.JE_JEITAPEX_XMLP_PKG dependencies on XLE_REGISTRATIONS_V

Line 135: XLE_REGISTRATIONS_V

131: SELECT
132: REGISTRATION_NUMBER
133: INTO C_TAXPAYER_ID
134: FROM
135: XLE_REGISTRATIONS_V
136: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID_V
137: AND LEGISLATIVE_CATEGORY = 'INCOME_TAX';
138: SELECT
139: REGISTRATION_NUMBER

Line 142: XLE_REGISTRATIONS_V

138: SELECT
139: REGISTRATION_NUMBER
140: INTO C_COMMERCIAL_NUM
141: FROM
142: XLE_REGISTRATIONS_V
143: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID_V
144: AND LEGISLATIVE_CATEGORY = 'COMMERCIAL_LAW';
145: EXCEPTION
146: WHEN TOO_MANY_ROWS THEN