DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_PERSON_TYPES

Line 24: p_person_type PER_PERSON_TYPES_TL.user_person_type%TYPE default null,

20: p_effective_date date,
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,

Line 48: USER_PERSN_TYPE PER_PERSON_TYPES_TL.user_person_type%TYPE,

44: EFFECTIVE_END_DATE varchar2(10),
45: BUSINESS_GROUP_ID PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE,
46: BUSINESS_GROUP_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE, -- (BASED ON LANG)
47: PERSON_TYPE_ID PER_ALL_PEOPLE_F.PERSON_TYPE_ID%TYPE,
48: USER_PERSN_TYPE PER_PERSON_TYPES_TL.user_person_type%TYPE,
49: SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,
50: LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE,
51: START_DATE varchar2(10),
52: APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,

Line 49: SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,

45: BUSINESS_GROUP_ID PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE,
46: BUSINESS_GROUP_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE, -- (BASED ON LANG)
47: PERSON_TYPE_ID PER_ALL_PEOPLE_F.PERSON_TYPE_ID%TYPE,
48: USER_PERSN_TYPE PER_PERSON_TYPES_TL.user_person_type%TYPE,
49: SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,
50: LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE,
51: START_DATE varchar2(10),
52: APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
53: BACKGROUND_CHECK_STATUS PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS%TYPE,