APPS.HR_PERSON_RECORD dependencies on HR_LOOKUPS

Line 25: p_employee_category hr_lookups.meaning%type default null,

21: p_employee_no per_all_people_f.employee_number%type default null,
22: p_applicant_no per_all_people_f.applicant_number%type default null,
23: p_cwk_no per_all_people_f.npw_number%type default null,
24: p_person_type PER_PERSON_TYPES_TL.user_person_type%TYPE default null,
25: p_employee_category hr_lookups.meaning%type default null,
26: p_employment_category hr_lookups.meaning%type default null,
27: p_phone_id per_phones.phone_id%type default null,
28: p_qualification_id per_qualifications.qualification_id%type default null,
29: p_delivery_method_id per_person_dlvry_methods.delivery_method_id%type default null,

Line 26: p_employment_category hr_lookups.meaning%type default null,

22: p_applicant_no per_all_people_f.applicant_number%type default null,
23: p_cwk_no per_all_people_f.npw_number%type default null,
24: p_person_type PER_PERSON_TYPES_TL.user_person_type%TYPE default null,
25: p_employee_category hr_lookups.meaning%type default null,
26: p_employment_category hr_lookups.meaning%type default null,
27: p_phone_id per_phones.phone_id%type default null,
28: p_qualification_id per_qualifications.qualification_id%type default null,
29: p_delivery_method_id per_person_dlvry_methods.delivery_method_id%type default null,
30: p_address_id per_addresses.address_id%type default null);

Line 914: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,

910: (DELIVERY_METHOD_ID PER_PERSON_DLVRY_METHODS.DELIVERY_METHOD_ID%TYPE,
911: DATE_START varchar2(10),
912: DATE_END varchar2(10),
913: COMM_DLVRY_METHOD PER_PERSON_DLVRY_METHODS.COMM_DLVRY_METHOD%TYPE,
914: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
915: PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
916: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
917: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
918: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,

Line 1065: PHONE_TYPE_DESC HR_LOOKUPS.MEANING%TYPE,

1061: PHONE_ID PER_PHONES.PHONE_ID%TYPE,
1062: DATE_FROM varchar2(10),
1063: DATE_TO varchar2(10),
1064: PHONE_TYPE PER_PHONES.PHONE_TYPE%TYPE,
1065: PHONE_TYPE_DESC HR_LOOKUPS.MEANING%TYPE,
1066: PHONE_NUMBER PER_PHONES.PHONE_NUMBER%TYPE,
1067: ATTRIBUTE_CATEGORY PER_PHONES.ATTRIBUTE_CATEGORY%TYPE,
1068: ATTRIBUTE1 PER_PHONES.ATTRIBUTE1%TYPE,
1069: ATTRIBUTE2 PER_PHONES.ATTRIBUTE2%TYPE,

Line 1108: SUBJECT_STATUS_DESC HR_LOOKUPS.MEANING%TYPE,

1104: SUBJECTS_TAKEN_ID PER_SUBJECTS_TAKEN.SUBJECTS_TAKEN_ID%TYPE,
1105: START_DATE VARCHAR2(10),
1106: MAJOR PER_SUBJECTS_TAKEN.MAJOR%TYPE,
1107: SUBJECT_STATUS PER_SUBJECTS_TAKEN.SUBJECT_STATUS%TYPE,
1108: SUBJECT_STATUS_DESC HR_LOOKUPS.MEANING%TYPE,
1109: SUBJECT PER_SUBJECTS_TAKEN.SUBJECT%TYPE,
1110: SUBJECT_DESC HR_LOOKUPS.MEANING%TYPE,
1111: GRADE_ATTAINED PER_SUBJECTS_TAKEN.GRADE_ATTAINED%TYPE,
1112: END_DATE VARCHAR2(10),

Line 1110: SUBJECT_DESC HR_LOOKUPS.MEANING%TYPE,

1106: MAJOR PER_SUBJECTS_TAKEN.MAJOR%TYPE,
1107: SUBJECT_STATUS PER_SUBJECTS_TAKEN.SUBJECT_STATUS%TYPE,
1108: SUBJECT_STATUS_DESC HR_LOOKUPS.MEANING%TYPE,
1109: SUBJECT PER_SUBJECTS_TAKEN.SUBJECT%TYPE,
1110: SUBJECT_DESC HR_LOOKUPS.MEANING%TYPE,
1111: GRADE_ATTAINED PER_SUBJECTS_TAKEN.GRADE_ATTAINED%TYPE,
1112: END_DATE VARCHAR2(10),
1113: ATTRIBUTE_CATEGORY PER_SUBJECTS_TAKEN.ATTRIBUTE_CATEGORY%TYPE,
1114: ATTRIBUTE1 PER_SUBJECTS_TAKEN.ATTRIBUTE1%TYPE,

Line 1165: STATUS_DESC HR_LOOKUPS.MEANING%TYPE,

1161: QUALIFICATION_ID PER_QUALIFICATIONS.QUALIFICATION_ID%type,
1162: TITLE PER_QUALIFICATIONS.TITLE%TYPE,
1163: GRADE_ATTAINED PER_QUALIFICATIONS.GRADE_ATTAINED%TYPE,
1164: STATUS PER_QUALIFICATIONS.STATUS%TYPE,
1165: STATUS_DESC HR_LOOKUPS.MEANING%TYPE,
1166: AWARDED_DATE VARCHAR2(10),
1167: FEE PER_QUALIFICATIONS.FEE%TYPE,
1168: FEE_CURRENCY PER_QUALIFICATIONS.FEE_CURRENCY%TYPE,
1169: FEE_CURRENCY_DESC FND_CURRENCIES_VL.NAME%TYPE,

Line 1182: TUITION_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,

1178: LICENSE_RESTRICTIONS PER_QUALIFICATIONS.LICENSE_RESTRICTIONS%TYPE,
1179: PROJECTED_COMPLETION_DATE VARCHAR2(10),
1180: AWARDING_BODY PER_QUALIFICATIONS.AWARDING_BODY%TYPE,
1181: TUITION_METHOD PER_QUALIFICATIONS.TUITION_METHOD%TYPE,
1182: TUITION_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
1183: GROUP_RANKING PER_QUALIFICATIONS.GROUP_RANKING%TYPE,
1184: COMMENTS PER_QUALIFICATIONS.COMMENTS%TYPE,
1185: QUALIFICATION_TYPE_ID PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID%TYPE,
1186: QUALIFICATION_TYPE_DESC PER_QUALIFICATION_TYPES_TL.NAME%TYPE,

Line 1214: SUBSCRIPTION_PAYMENT_DESC HR_LOOKUPS.MEANING%TYPE,

1210: PROFESSIONAL_BODY_NAME PER_QUALIFICATIONS.PROFESSIONAL_BODY_NAME%TYPE,
1211: MEMBERSHIP_NUMBER PER_QUALIFICATIONS.MEMBERSHIP_NUMBER%TYPE,
1212: MEMBERSHIP_CATEGORY PER_QUALIFICATIONS.MEMBERSHIP_CATEGORY%TYPE,
1213: SUBSCRIPTION_PAYMENT_METHOD PER_QUALIFICATIONS.SUBSCRIPTION_PAYMENT_METHOD%TYPE,
1214: SUBSCRIPTION_PAYMENT_DESC HR_LOOKUPS.MEANING%TYPE,
1215: QUA_INFORMATION_CATEGORY PER_QUALIFICATIONS.QUA_INFORMATION_CATEGORY%TYPE,
1216: QUA_INFORMATION1 PER_QUALIFICATIONS.QUA_INFORMATION1%TYPE,
1217: QUA_INFORMATION2 PER_QUALIFICATIONS.QUA_INFORMATION2%TYPE,
1218: QUA_INFORMATION3 PER_QUALIFICATIONS.QUA_INFORMATION3%TYPE,