DBA Data[Home] [Help]

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 243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')

239: , PRIMARY_FLAG PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG%TYPE -- CHECK BOX
240: , APPLICATION_ID PER_ALL_ASSIGNMENTS_F.APPLICATION_ID%TYPE
241: , ASSIGNMENT_NUMBER PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE
242: , CHANGE_REASON PER_ALL_ASSIGNMENTS_F.CHANGE_REASON%TYPE
243: , CHANGE_REASON_DESC FND_LOOKUP_VALUES.MEANING%TYPE -- (BASED ON LANG /'E','EMP_ASSIGN_REASON', 'C', 'CWK_ASSIGN_REASON')
244: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
245: , DATE_PROBATION_END varchar2(10)
246: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
247: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE

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

244: , COMMENT_ID PER_ALL_ASSIGNMENTS_F.COMMENT_ID%TYPE
245: , DATE_PROBATION_END varchar2(10)
246: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
247: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
248: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
249: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX

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

246: , DEFAULT_CODE_COMB_ID PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID%TYPE
247: , EMPLOYMENT_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY%TYPE
248: , EMPLOYMENT_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMP_CAT')
249: , FREQUENCY PER_ALL_ASSIGNMENTS_F.FREQUENCY%TYPE
250: , FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
251: , INTERNAL_ADDRESS_LINE PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE%TYPE
252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE

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

252: , MANAGER_FLAG PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG%TYPE -- CHECK BOX
253: , NORMAL_HOURS PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS%TYPE
254: , PERF_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD%TYPE
255: , PERF_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY%TYPE
256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')

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

256: , PERF_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
257: , PERIOD_OF_SERVICE_ID PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID%TYPE
258: , PROBATION_PERIOD PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD%TYPE
259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE

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

259: , PROBATION_UNIT PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT%TYPE
260: , PROBATION_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'QUALIFYING_UNITS')
261: , SAL_REVIEW_PERIOD PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD%TYPE
262: , SAL_REVIEW_PERIOD_FREQUENCY PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY%TYPE
263: , SAL_RP_FREQUENCY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'FREQUENCY')
264: , SET_OF_BOOKS_ID PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID%TYPE
265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE

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

265: , SOURCE_TYPE PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE%TYPE
266: , TIME_NORMAL_FINISH PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH%TYPE
267: , TIME_NORMAL_START PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START%TYPE
268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
271: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
272: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
273: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE

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

268: , BARGAINING_UNIT_CODE PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE%TYPE
269: , BARGAINING_UNIT_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'BARGAINING_UNIT_CODE')
270: , LABOUR_UNION_MEMBER_FLAG PER_ALL_ASSIGNMENTS_F.LABOUR_UNION_MEMBER_FLAG%TYPE -- CHECK BOX
271: , HOURLY_SALARIED_CODE PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE%TYPE
272: , HOURLY_SALARIED_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'HOURLY_SALARIED_CODE')
273: , CONTRACT_ID PER_ALL_ASSIGNMENTS_F.CONTRACT_ID%TYPE
274: , COLLECTIVE_AGREEMENT_ID PER_ALL_ASSIGNMENTS_F.COLLECTIVE_AGREEMENT_ID%TYPE
275: , COLLECTIVE_AGREEMENT_DESC PER_COLLECTIVE_AGREEMENTS.NAME%TYPE
276: , CAGR_ID_FLEX_NUM PER_ALL_ASSIGNMENTS_F.CAGR_ID_FLEX_NUM%TYPE

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

311: , TITLE PER_ALL_ASSIGNMENTS_F.TITLE%TYPE
312: , NOTICE_PERIOD PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD%TYPE
313: , NOTICE_PERIOD_UOM PER_ALL_ASSIGNMENTS_F.NOTICE_PERIOD_UOM%TYPE
314: , EMPLOYEE_CATEGORY PER_ALL_ASSIGNMENTS_F.EMPLOYEE_CATEGORY%TYPE
315: , EMPLOYEE_CATEGORY_DESC FND_LOOKUP_VALUES.MEANING%TYPE --(BASED ON LANG /'EMPLOYEE_CATG')
316: , WORK_AT_HOME PER_ALL_ASSIGNMENTS_F.WORK_AT_HOME%TYPE -- CHECK BOX
317: , JOB_POST_SOURCE_NAME PER_ALL_ASSIGNMENTS_F.JOB_POST_SOURCE_NAME%TYPE
318: , POSTING_CONTENT_ID PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID%TYPE
319: , PERIOD_OF_PLACEMENT_DATE_START varchar2(10)

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

445: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
446: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
447: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
448: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
449: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
450: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
451: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
452: DATE_TO varchar2(10),
453: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,

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

510: ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%TYPE,
511: ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%TYPE,
512: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
513: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
514: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
515: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
516: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
517: DATE_TO varchar2(10),
518: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,