[Home] [Help]
380: CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
381: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
382: CONTACT_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
383: CONTACT_TYPE PER_CONTACT_RELATIONSHIPS.CONTACT_TYPE%TYPE,
384: CONTACT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE, -- 'CONTACT'
385: PRIMARY_CONTACT_FLAG PER_CONTACT_RELATIONSHIPS.PRIMARY_CONTACT_FLAG%TYPE,
386: DATE_START varchar2(10),
387: START_LIFE_REASON_ID PER_CONTACT_RELATIONSHIPS.START_LIFE_REASON_ID%TYPE,
388: DATE_END varchar2(10),
696: TYPE WORK_INC_INFO is Record
697: (INCIDENT_ID PER_WORK_INCIDENTS.INCIDENT_ID%TYPE,
698: INCIDENT_REFERENCE PER_WORK_INCIDENTS.INCIDENT_REFERENCE%TYPE,
699: INCIDENT_TYPE PER_WORK_INCIDENTS.INCIDENT_TYPE%TYPE,
700: INCIDENT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
701: INCIDENT_DATE varchar2(10),
702: INCIDENT_TIME PER_WORK_INCIDENTS.INCIDENT_TIME%TYPE,
703: ASSIGNMENT_ID PER_WORK_INCIDENTS.ASSIGNMENT_ID%TYPE,
704: LOCATION PER_WORK_INCIDENTS.LOCATION%TYPE,
702: INCIDENT_TIME PER_WORK_INCIDENTS.INCIDENT_TIME%TYPE,
703: ASSIGNMENT_ID PER_WORK_INCIDENTS.ASSIGNMENT_ID%TYPE,
704: LOCATION PER_WORK_INCIDENTS.LOCATION%TYPE,
705: AT_WORK_FLAG PER_WORK_INCIDENTS.AT_WORK_FLAG%TYPE,
706: AT_WORK_FLAG_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
707: --LAST_WORK_DATE varchar2(10), -- comented for bug 8905622
708: --LAST_WORK_TIME PER_WORK_INCIDENTS.LAST_WORK_TIME%TYPE, -- comented for bug 8905622
709: REPORT_DATE varchar2(10),
710: REPORT_TIME PER_WORK_INCIDENTS.REPORT_TIME%TYPE,
714: PERSON_REPORTED_TO PER_WORK_INCIDENTS.PERSON_REPORTED_TO%TYPE,
715: WITNESS_DETAILS PER_WORK_INCIDENTS.WITNESS_DETAILS%TYPE,
716: DESCRIPTION PER_WORK_INCIDENTS.DESCRIPTION%TYPE,
717: INJURY_TYPE PER_WORK_INCIDENTS.INJURY_TYPE%TYPE,
718: INJURY_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
719: DISEASE_TYPE PER_WORK_INCIDENTS.DISEASE_TYPE%TYPE,
720: DISEASE_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
721: HAZARD_TYPE PER_WORK_INCIDENTS.HAZARD_TYPE%TYPE,
722: HAZARD_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
716: DESCRIPTION PER_WORK_INCIDENTS.DESCRIPTION%TYPE,
717: INJURY_TYPE PER_WORK_INCIDENTS.INJURY_TYPE%TYPE,
718: INJURY_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
719: DISEASE_TYPE PER_WORK_INCIDENTS.DISEASE_TYPE%TYPE,
720: DISEASE_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
721: HAZARD_TYPE PER_WORK_INCIDENTS.HAZARD_TYPE%TYPE,
722: HAZARD_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
723: BODY_PART PER_WORK_INCIDENTS.BODY_PART%TYPE,
724: TREATMENT_RECEIVED_FLAG PER_WORK_INCIDENTS.TREATMENT_RECEIVED_FLAG%TYPE,
718: INJURY_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
719: DISEASE_TYPE PER_WORK_INCIDENTS.DISEASE_TYPE%TYPE,
720: DISEASE_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
721: HAZARD_TYPE PER_WORK_INCIDENTS.HAZARD_TYPE%TYPE,
722: HAZARD_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
723: BODY_PART PER_WORK_INCIDENTS.BODY_PART%TYPE,
724: TREATMENT_RECEIVED_FLAG PER_WORK_INCIDENTS.TREATMENT_RECEIVED_FLAG%TYPE,
725: HOSPITAL_DETAILS PER_WORK_INCIDENTS.HOSPITAL_DETAILS%TYPE,
726: --DOCTOR_ID PER_WORK_INCIDENTS.DOCTOR_ID%TYPE,-- comented for bug 8905622
835: EMPLOYER_COUNTRY PER_PREVIOUS_EMPLOYERS.EMPLOYER_COUNTRY%TYPE,
836: EMPLOYER_COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
837: EMPLOYER_ADDRESS PER_PREVIOUS_EMPLOYERS.EMPLOYER_ADDRESS%TYPE,
838: EMPLOYER_TYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE%TYPE,
839: EMPLOYER_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
840: EMPLOYER_SUBTYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE%TYPE,
841: EMPLOYER_SUBTYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
842: DESCRIPTION PER_PREVIOUS_EMPLOYERS.DESCRIPTION%TYPE,
843: PEM_ATTRIBUTE_CATEGORY PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE_CATEGORY%TYPE,
837: EMPLOYER_ADDRESS PER_PREVIOUS_EMPLOYERS.EMPLOYER_ADDRESS%TYPE,
838: EMPLOYER_TYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE%TYPE,
839: EMPLOYER_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
840: EMPLOYER_SUBTYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE%TYPE,
841: EMPLOYER_SUBTYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
842: DESCRIPTION PER_PREVIOUS_EMPLOYERS.DESCRIPTION%TYPE,
843: PEM_ATTRIBUTE_CATEGORY PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE_CATEGORY%TYPE,
844: PEM_ATTRIBUTE1 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE1%TYPE,
845: PEM_ATTRIBUTE2 PER_PREVIOUS_EMPLOYERS.PEM_ATTRIBUTE2%TYPE,