eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLE_UTILITIES_GRP dependencies on XLE_JURISDICTIONS_VL

Line 10: legislative_cat_code XLE_JURISDICTIONS_VL.LEGISLATIVE_CAT_CODE%TYPE

6: -- TYPE RegNum_tbl_type IS TABLE OF XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7:
8: TYPE RegNum_Rec IS RECORD (
9: registration_number XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
10: legislative_cat_code XLE_JURISDICTIONS_VL.LEGISLATIVE_CAT_CODE%TYPE
11: );
12: TYPE RegNum_tbl_type IS TABLE OF RegNum_Rec INDEX BY BINARY_INTEGER;
13:
14: TYPE PartyClass_Rec IS RECORD (

Line 89: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

85: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
86: REGISTERED_NAME XLE_REGISTRATIONS.registered_name%TYPE,
87: ALTERNATE_REGISTERED_NAME XLE_REGISTRATIONS.alternate_registered_name%TYPE,
88: identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%TYPE,
89: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
90: LEGALAUTH_NAME HZ_PARTIES.PARTY_NAME%TYPE,
91: LEGALAUTH_ADDRESS VARCHAR2(1000),
92: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
93: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

Line 122: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

118: ETB_EFFECTIVE_FROM XLE_ETB_PROFILES.EFFECTIVE_FROM%TYPE,
119: ETB_EFFECTIVE_TO XLE_ETB_PROFILES.EFFECTIVE_TO%TYPE,
120: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
121: identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%TYPE,
122: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
123: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
124: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
125: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
126: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

Line 152: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,

148: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
149: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
150: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
151: identifying_flag XLE_REGISTRATIONS.IDENTIFYING_FLAG%TYPE,
152: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
153: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
154: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
155: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
156: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,