APPS.PER_PERUSHRM_XMLP_PKG dependencies on PER_PEOPLE_F

Line 859: v_person_id per_people_f.person_id%TYPE;

855: and hoi4.org_information1(+) = nvl(P_STATE_CODE,hoi4.org_information1(+))
856: order by 4,2,3;
857:
858:
859: v_person_id per_people_f.person_id%TYPE;
860: v_first_name per_people_f.first_name%TYPE;
861: v_last_name per_people_f.last_name%TYPE;
862: v_state hr_locations_all.region_2%TYPE;
863: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';

Line 860: v_first_name per_people_f.first_name%TYPE;

856: order by 4,2,3;
857:
858:
859: v_person_id per_people_f.person_id%TYPE;
860: v_first_name per_people_f.first_name%TYPE;
861: v_last_name per_people_f.last_name%TYPE;
862: v_state hr_locations_all.region_2%TYPE;
863: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
864: g_delimiter varchar2(1) := fnd_global.local_chr(10);

Line 861: v_last_name per_people_f.last_name%TYPE;

857:
858:
859: v_person_id per_people_f.person_id%TYPE;
860: v_first_name per_people_f.first_name%TYPE;
861: v_last_name per_people_f.last_name%TYPE;
862: v_state hr_locations_all.region_2%TYPE;
863: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
864: g_delimiter varchar2(1) := fnd_global.local_chr(10);
865:

Line 880: UPDATE per_people_f

876: hr_utility.trace('v_person_id = ' || to_char(v_person_id));
877: hr_utility.trace('v_state = ' || v_state);
878:
879: if p_report_mode = 'F' then
880: UPDATE per_people_f
881: SET per_information7 = 'DONE'
882: WHERE person_id = v_person_id
883: AND per_information7 = 'INCL';
884: end if;