DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on HR_ALL_ORGANIZATION_UNITS

Line 18: p_bgrp_name hr_all_organization_units.name%type default null,

14: p_end_person_id per_all_people_f.person_id%type default null,
15: p_assignment_id per_all_assignments_f.assignment_id%type default null,
16: p_first_name per_all_people_f.first_name%type default null,
17: p_last_name per_all_people_f.last_name%type default null,
18: p_bgrp_name hr_all_organization_units.name%type default null,
19: p_bgrp_id hr_all_organization_units.business_group_id%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,

Line 19: p_bgrp_id hr_all_organization_units.business_group_id%type default null,

15: p_assignment_id per_all_assignments_f.assignment_id%type default null,
16: p_first_name per_all_people_f.first_name%type default null,
17: p_last_name per_all_people_f.last_name%type default null,
18: p_bgrp_name hr_all_organization_units.name%type default null,
19: p_bgrp_id hr_all_organization_units.business_group_id%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,

Line 46: BUSINESS_GROUP_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE, -- (BASED ON LANG)

42: PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
43: EFFECTIVE_START_DATE varchar2(10),
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,

Line 230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)

226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
230: , ORGANIZATION_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE -- (BASED ON LANG)
231: , PEOPLE_GROUP_ID PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID%TYPE
232: , SOFT_CODING_KEYFLEX_ID PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE
233: , VACANCY_ID PER_ALL_ASSIGNMENTS_F.VACANCY_ID%TYPE
234: , VACANCY_DESC PER_VACANCIES.NAME%TYPE