APPS.PQP_HROSS_INTEGRATION_SWI dependencies on PER_PEOPLE_EXTRA_INFO

Line 1208: FROM per_people_extra_info pei

1204: Cursor csr_pei (p_person_id IN Number
1205: ,p_person_extra_info_id IN Number
1206: ,p_information_type IN Varchar2) Is
1207: SELECT *
1208: FROM per_people_extra_info pei
1209: WHERE pei.person_id = p_person_id
1210: AND pei.person_extra_info_id = p_person_extra_info_id
1211: AND pei.information_type = p_information_type;
1212:

Line 1214: l_extra_info_rec per_people_extra_info%ROWTYPE;

1210: AND pei.person_extra_info_id = p_person_extra_info_id
1211: AND pei.information_type = p_information_type;
1212:
1213: l_proc CONSTANT Varchar2(150) := g_package ||'InsUpd_Person_Extra_Info';
1214: l_extra_info_rec per_people_extra_info%ROWTYPE;
1215: l_old_info_rec per_people_extra_info%ROWTYPE;
1216: l_error_msg varchar2(2000);
1217: l_msg_data varchar2(4000);
1218: l_validate Boolean;

Line 1215: l_old_info_rec per_people_extra_info%ROWTYPE;

1211: AND pei.information_type = p_information_type;
1212:
1213: l_proc CONSTANT Varchar2(150) := g_package ||'InsUpd_Person_Extra_Info';
1214: l_extra_info_rec per_people_extra_info%ROWTYPE;
1215: l_old_info_rec per_people_extra_info%ROWTYPE;
1216: l_error_msg varchar2(2000);
1217: l_msg_data varchar2(4000);
1218: l_validate Boolean;
1219: BEGIN