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_BUSINESSINFO_GRP dependencies on XLE_REGISTRATIONS

Line 40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

36: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
37: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
41: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

Line 42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

38: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
41: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

Line 43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

39: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
41: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

Line 70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

66: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
67: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
71: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

Line 72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

68: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
71: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

Line 73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

69: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
71: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

Line 101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

97: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
98: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
102: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

Line 103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

99: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
102: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

Line 104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

100: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
102: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

Line 182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

178: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
179: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
183: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,

Line 184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

180: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
183: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

Line 185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

181: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
183: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

Line 239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

235: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
236: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
240: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

Line 241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

237: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
240: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

Line 242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

238: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
240: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

Line 275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,

271: sub_activity_code XLE_ENTITY_PROFILES.SUB_ACTIVITY_CODE%TYPE,
272: type_of_company XLE_ENTITY_PROFILES.type_of_company%TYPE,
273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
276: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,

Line 277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,

273: LE_EFFECTIVE_FROM XLE_ENTITY_PROFILES.EFFECTIVE_FROM%TYPE,
274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
276: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

Line 278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,

274: LE_EFFECTIVE_TO XLE_ENTITY_PROFILES.EFFECTIVE_TO%TYPE,
275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
276: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,