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 798: pp_ei per_people_extra_info%rowtype)

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

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

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

Line 1088: pp_ei per_people_extra_info%rowtype)

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

Line 4034: l_per_ei_data per_people_extra_info%rowtype;

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

Line 4048: l_people_ei_row per_people_extra_info%rowtype;

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