DBA Data[Home] [Help]

APPS.JE_JEITXLRG_XMLP_PKG dependencies on XLE_REGISTRATIONS_V

Line 113: XLE_REGISTRATIONS_V

109: SELECT
110: REGISTRATION_NUMBER
111: INTO C_TAXPAYER_ID
112: FROM
113: XLE_REGISTRATIONS_V
114: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
115: AND LEGISLATIVE_CATEGORY = 'INCOME_TAX';
116: SELECT
117: REGISTRATION_NUMBER

Line 120: XLE_REGISTRATIONS_V

116: SELECT
117: REGISTRATION_NUMBER
118: INTO C_COMMERCIAL_NUM
119: FROM
120: XLE_REGISTRATIONS_V
121: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
122: AND LEGISLATIVE_CATEGORY = 'COMMERCIAL_LAW';
123: SELECT
124: SUBSTR(XFIV.ADDRESS_LINE_1