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.HR_PERSON_RECORD dependencies on FND_LOOKUP_VALUES

Line 56: BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')

52: APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
53: BACKGROUND_CHECK_STATUS PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS%TYPE,
54: BACKGROUND_DATE_CHECK varchar2(10),
55: BLOOD_TYPE PER_ALL_PEOPLE_F.BLOOD_TYPE%TYPE,
56: BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')
57: COMMENT_ID PER_ALL_PEOPLE_F.COMMENT_ID%TYPE,
58: CORRESPONDENCE_LANGUAGE PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE%TYPE,
59: CORRESPONDENCE_LANGUAGE_DESC FND_LANGUAGES_VL.DESCRIPTION%TYPE,
60: CURRENT_APPLICANT_FLAG PER_ALL_PEOPLE_F.CURRENT_APPLICANT_FLAG%TYPE,

Line 80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')

76: LAST_MEDICAL_TEST_BY PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY%TYPE,
77: LAST_MEDICAL_TEST_DATE varchar2(10),
78: MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
79: MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
81: MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE,
82: NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
84: NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,

Line 83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')

79: MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
81: MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE,
82: NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
84: NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,
85: NATIONAL_ID_LABEL VARCHAR2(200),
86: OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
87: ON_MILITARY_SERVICE PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE%TYPE,

Line 100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')

96: RESUME_LAST_UPDATED varchar2(10),
97: REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
98: SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
99: SEX PER_ALL_PEOPLE_F.SEX%TYPE,
100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,

Line 102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')

98: SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
99: SEX PER_ALL_PEOPLE_F.SEX%TYPE,
100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,

Line 105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')

101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
109: WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,

Line 108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')

104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
109: WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,
110: COORD_BEN_MED_PLN_NO PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO%TYPE,
111: COORD_BEN_NO_CVG_FLAG PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG%TYPE, -- CHECK BOX
112: DPDNT_ADOPTION_DATE varchar2(10),

Line 116: USES_TOBACCO_FLAG_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'TOBACCO_USER')

112: DPDNT_ADOPTION_DATE varchar2(10),
113: DPDNT_VLNTRY_SVCE_FLAG PER_ALL_PEOPLE_F.DPDNT_VLNTRY_SVCE_FLAG%TYPE, -- CHECK BOX
114: RECEIPT_OF_DEATH_CERT_DATE varchar2(10),
115: USES_TOBACCO_FLAG PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG%TYPE,
116: USES_TOBACCO_FLAG_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'TOBACCO_USER')
117: BENEFIT_GROUP_ID PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID%TYPE,
118: BENEFIT_GROUP_NAME BEN_BENFTS_GRP.NAME%TYPE,
119: ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
120: ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,

Line 250: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')

246: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
247: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
248: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
249: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
250: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
251: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
252: , DATE_PROBATION_END varchar2(10)
253: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
254: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE

Line 255: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')

251: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
252: , DATE_PROBATION_END varchar2(10)
253: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
254: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
255: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
256: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
257: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
258: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
259: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX

Line 257: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')

253: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
254: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
255: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
256: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
257: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
258: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
259: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
260: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
261: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE

Line 263: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')

259: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
260: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
261: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
262: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
263: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
265: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
266: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
267: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')

Line 267: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')

263: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
265: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
266: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
267: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
268: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
269: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
270: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
271: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE

Line 270: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')

266: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
267: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
268: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
269: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
270: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
271: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
272: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
273: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
274: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE

Line 276: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')

272: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
273: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
274: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
275: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
276: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
277: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
278: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
279: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
280: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE

Line 279: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')

275: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
276: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
277: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
278: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
279: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
280: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
281: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
282: , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
283: , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE

Line 322: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')

318: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
319: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
320: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
321: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
322: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
323: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
324: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
325: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
326: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)

Line 456: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')

452: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
453: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
454: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
455: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
456: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
457: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
458: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
459: DATE_TO varchar2(10),
460: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,

Line 521: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')

517: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
518: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
519: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
520: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
521: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
522: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
523: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
524: DATE_TO varchar2(10),
525: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,