APPS.PER_PERUSHRM_XMLP_PKG dependencies on PER_PEOPLE_F

Line 867: v_person_id per_people_f.person_id%TYPE;

863: and hoi4.org_information1(+) = nvl(P_STATE_CODE,hoi4.org_information1(+))
864: order by 4,2,3;
865:
866:
867: v_person_id per_people_f.person_id%TYPE;
868: v_first_name per_people_f.first_name%TYPE;
869: v_last_name per_people_f.last_name%TYPE;
870: v_state hr_locations_all.region_2%TYPE;
871: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';

Line 868: v_first_name per_people_f.first_name%TYPE;

864: order by 4,2,3;
865:
866:
867: v_person_id per_people_f.person_id%TYPE;
868: v_first_name per_people_f.first_name%TYPE;
869: v_last_name per_people_f.last_name%TYPE;
870: v_state hr_locations_all.region_2%TYPE;
871: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
872: g_delimiter varchar2(1) := fnd_global.local_chr(10);

Line 869: v_last_name per_people_f.last_name%TYPE;

865:
866:
867: v_person_id per_people_f.person_id%TYPE;
868: v_first_name per_people_f.first_name%TYPE;
869: v_last_name per_people_f.last_name%TYPE;
870: v_state hr_locations_all.region_2%TYPE;
871: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
872: g_delimiter varchar2(1) := fnd_global.local_chr(10);
873:

Line 888: UPDATE per_people_f

884: hr_utility.trace('v_person_id = ' || to_char(v_person_id));
885: hr_utility.trace('v_state = ' || v_state);
886:
887: if p_report_mode = 'F' then
888: UPDATE per_people_f
889: SET per_information7 = 'DONE'
890: WHERE person_id = v_person_id
891: AND per_information7 = 'INCL';
892: end if;