DBA Data[Home] [Help]

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 905: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,

901: (DELIVERY_METHOD_ID PER_PERSON_DLVRY_METHODS.DELIVERY_METHOD_ID%TYPE,
902: DATE_START varchar2(10),
903: DATE_END varchar2(10),
904: COMM_DLVRY_METHOD PER_PERSON_DLVRY_METHODS.COMM_DLVRY_METHOD%TYPE,
905: COMM_DLVRY_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
906: PREFERRED_FLAG PER_PERSON_DLVRY_METHODS.PREFERRED_FLAG%TYPE,
907: ATTRIBUTE_CATEGORY PER_PERSON_DLVRY_METHODS.ATTRIBUTE_CATEGORY%TYPE,
908: ATTRIBUTE1 PER_PERSON_DLVRY_METHODS.ATTRIBUTE1%TYPE,
909: ATTRIBUTE2 PER_PERSON_DLVRY_METHODS.ATTRIBUTE2%TYPE,

Line 1056: PHONE_TYPE_DESC HR_LOOKUPS.MEANING%TYPE,

1052: PHONE_ID PER_PHONES.PHONE_ID%TYPE,
1053: DATE_FROM varchar2(10),
1054: DATE_TO varchar2(10),
1055: PHONE_TYPE PER_PHONES.PHONE_TYPE%TYPE,
1056: PHONE_TYPE_DESC HR_LOOKUPS.MEANING%TYPE,
1057: PHONE_NUMBER PER_PHONES.PHONE_NUMBER%TYPE,
1058: ATTRIBUTE_CATEGORY PER_PHONES.ATTRIBUTE_CATEGORY%TYPE,
1059: ATTRIBUTE1 PER_PHONES.ATTRIBUTE1%TYPE,
1060: ATTRIBUTE2 PER_PHONES.ATTRIBUTE2%TYPE,

Line 1099: SUBJECT_STATUS_DESC HR_LOOKUPS.MEANING%TYPE,

1095: SUBJECTS_TAKEN_ID PER_SUBJECTS_TAKEN.SUBJECTS_TAKEN_ID%TYPE,
1096: START_DATE VARCHAR2(10),
1097: MAJOR PER_SUBJECTS_TAKEN.MAJOR%TYPE,
1098: SUBJECT_STATUS PER_SUBJECTS_TAKEN.SUBJECT_STATUS%TYPE,
1099: SUBJECT_STATUS_DESC HR_LOOKUPS.MEANING%TYPE,
1100: SUBJECT PER_SUBJECTS_TAKEN.SUBJECT%TYPE,
1101: SUBJECT_DESC HR_LOOKUPS.MEANING%TYPE,
1102: GRADE_ATTAINED PER_SUBJECTS_TAKEN.GRADE_ATTAINED%TYPE,
1103: END_DATE VARCHAR2(10),

Line 1101: SUBJECT_DESC HR_LOOKUPS.MEANING%TYPE,

1097: MAJOR PER_SUBJECTS_TAKEN.MAJOR%TYPE,
1098: SUBJECT_STATUS PER_SUBJECTS_TAKEN.SUBJECT_STATUS%TYPE,
1099: SUBJECT_STATUS_DESC HR_LOOKUPS.MEANING%TYPE,
1100: SUBJECT PER_SUBJECTS_TAKEN.SUBJECT%TYPE,
1101: SUBJECT_DESC HR_LOOKUPS.MEANING%TYPE,
1102: GRADE_ATTAINED PER_SUBJECTS_TAKEN.GRADE_ATTAINED%TYPE,
1103: END_DATE VARCHAR2(10),
1104: ATTRIBUTE_CATEGORY PER_SUBJECTS_TAKEN.ATTRIBUTE_CATEGORY%TYPE,
1105: ATTRIBUTE1 PER_SUBJECTS_TAKEN.ATTRIBUTE1%TYPE,

Line 1156: STATUS_DESC HR_LOOKUPS.MEANING%TYPE,

1152: QUALIFICATION_ID PER_QUALIFICATIONS.QUALIFICATION_ID%type,
1153: TITLE PER_QUALIFICATIONS.TITLE%TYPE,
1154: GRADE_ATTAINED PER_QUALIFICATIONS.GRADE_ATTAINED%TYPE,
1155: STATUS PER_QUALIFICATIONS.STATUS%TYPE,
1156: STATUS_DESC HR_LOOKUPS.MEANING%TYPE,
1157: AWARDED_DATE VARCHAR2(10),
1158: FEE PER_QUALIFICATIONS.FEE%TYPE,
1159: FEE_CURRENCY PER_QUALIFICATIONS.FEE_CURRENCY%TYPE,
1160: FEE_CURRENCY_DESC FND_CURRENCIES_VL.NAME%TYPE,

Line 1173: TUITION_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,

1169: LICENSE_RESTRICTIONS PER_QUALIFICATIONS.LICENSE_RESTRICTIONS%TYPE,
1170: PROJECTED_COMPLETION_DATE VARCHAR2(10),
1171: AWARDING_BODY PER_QUALIFICATIONS.AWARDING_BODY%TYPE,
1172: TUITION_METHOD PER_QUALIFICATIONS.TUITION_METHOD%TYPE,
1173: TUITION_METHOD_DESC HR_LOOKUPS.MEANING%TYPE,
1174: GROUP_RANKING PER_QUALIFICATIONS.GROUP_RANKING%TYPE,
1175: COMMENTS PER_QUALIFICATIONS.COMMENTS%TYPE,
1176: QUALIFICATION_TYPE_ID PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID%TYPE,
1177: QUALIFICATION_TYPE_DESC PER_QUALIFICATION_TYPES_TL.NAME%TYPE,

Line 1205: SUBSCRIPTION_PAYMENT_DESC HR_LOOKUPS.MEANING%TYPE,

1201: PROFESSIONAL_BODY_NAME PER_QUALIFICATIONS.PROFESSIONAL_BODY_NAME%TYPE,
1202: MEMBERSHIP_NUMBER PER_QUALIFICATIONS.MEMBERSHIP_NUMBER%TYPE,
1203: MEMBERSHIP_CATEGORY PER_QUALIFICATIONS.MEMBERSHIP_CATEGORY%TYPE,
1204: SUBSCRIPTION_PAYMENT_METHOD PER_QUALIFICATIONS.SUBSCRIPTION_PAYMENT_METHOD%TYPE,
1205: SUBSCRIPTION_PAYMENT_DESC HR_LOOKUPS.MEANING%TYPE,
1206: QUA_INFORMATION_CATEGORY PER_QUALIFICATIONS.QUA_INFORMATION_CATEGORY%TYPE,
1207: QUA_INFORMATION1 PER_QUALIFICATIONS.QUA_INFORMATION1%TYPE,
1208: QUA_INFORMATION2 PER_QUALIFICATIONS.QUA_INFORMATION2%TYPE,
1209: QUA_INFORMATION3 PER_QUALIFICATIONS.QUA_INFORMATION3%TYPE,