APPS.GHR_MTO_INT dependencies on PER_PEOPLE_EXTRA_INFO

Line 274: from per_people_extra_info

270: p_value varchar2) is
271:
272: cursor cur_pei_id is
273: select person_extra_info_id, object_version_number
274: from per_people_extra_info
275: where person_id = p_person_id
276: and information_type = 'GHR_US_PER_GROUP1';
277:
278: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;

Line 278: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;

274: from per_people_extra_info
275: where person_id = p_person_id
276: and information_type = 'GHR_US_PER_GROUP1';
277:
278: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
279: l_object_version_number per_people_extra_info.object_version_number%type;
280:
281: l_proc varchar2(72) := g_package||'update_agency_transfer_from';
282:

Line 279: l_object_version_number per_people_extra_info.object_version_number%type;

275: where person_id = p_person_id
276: and information_type = 'GHR_US_PER_GROUP1';
277:
278: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
279: l_object_version_number per_people_extra_info.object_version_number%type;
280:
281: l_proc varchar2(72) := g_package||'update_agency_transfer_from';
282:
283: begin

Line 799: pp_ei per_people_extra_info%rowtype)

795: end;
796:
797: procedure insert_people_ei(p_transfer_name varchar2,
798: p_effective_date date,
799: pp_ei per_people_extra_info%rowtype)
800: is
801:
802: l_info3_meaning varchar2(80) := null;
803: l_info4_meaning varchar2(80) := null;

Line 813: l_table_name constant varchar2(30) := 'PER_PEOPLE_EXTRA_INFO';

809: l_info10_meaning varchar2(80) := null;
810: l_info11_meaning varchar2(240) := null; --Bug# 12644378
811:
812: l_proc varchar2(72) := g_package||'insert_people_ei';
813: l_table_name constant varchar2(30) := 'PER_PEOPLE_EXTRA_INFO';
814: l_name varchar2(30);
815:
816: begin
817:

Line 1089: pp_ei per_people_extra_info%rowtype)

1085: end;
1086:
1087: procedure update_people_ei(p_transfer_name varchar2,
1088: p_effective_date date,
1089: pp_ei per_people_extra_info%rowtype)
1090: is
1091:
1092: l_info3_meaning varchar2(80) := null;
1093: l_info4_meaning varchar2(80) := null;

Line 4035: l_per_ei_data per_people_extra_info%rowtype;

4031: l_grade_id per_assignments_f.grade_id%type;
4032: l_business_group_id per_assignments_f.business_group_id%type;
4033:
4034: l_pos_ei_data per_position_extra_info%rowtype;
4035: l_per_ei_data per_people_extra_info%rowtype;
4036: l_asg_ei_data per_assignment_extra_info%rowtype;
4037: l_special_info ghr_api.special_information_type;
4038:
4039: l_adj_basic_pay number;

Line 4049: l_people_ei_row per_people_extra_info%rowtype;

4045:
4046: ---------------
4047: l_people_row per_all_people_f%rowtype;
4048: l_position_row hr_all_positions_f%rowtype;
4049: l_people_ei_row per_people_extra_info%rowtype;
4050: l_element ghr_mt_element_entries_v%rowtype;
4051: l_misc ghr_mt_misc_v%rowtype;
4052:
4053: l_pos_defs per_position_definitions%rowtype;