APPS.GHR_SF52_PRE_UPDATE dependencies on PER_POSITIONS

Line 793: l_position_id per_positions.position_id%type;

789: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
790: l_pos_extra_info_rec per_position_extra_info%rowtype;
791: l_proc varchar2(70) := 'Retrieve_all_extra_info';
792: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
793: l_position_id per_positions.position_id%type;
794: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
795: l_session ghr_history_api.g_session_var_type;
796: l_person_status per_assignment_status_types.user_status%type;
797:

Line 1563: l_position_id per_positions.position_id%type;

1559: --
1560: l_bus_gp number;
1561: l_agency_code varchar2(50);
1562: l_proc varchar2(70) := 'SF52_br_extra_info';
1563: l_position_id per_positions.position_id%type;
1564:
1565: --
1566: --Bug# 957677 -- Parameter Name Change
1567: cursor c_bus_gp(p_position_id number) is

Line 1911: -- row into the history for the table PER_POSITIONS_EXTRA_INFO and thereby making the Position

1907: hr_utility.set_location(l_proc,95);
1908: --
1909: --
1910: -- Bug 3226555 Commented below code as they can never be equal. It was unnecessarily inserting a
1911: -- row into the history for the table PER_POSITIONS_EXTRA_INFO and thereby making the Position
1912: -- status as invalid when cancellation to any action was done.
1913: /* If p_pa_request_rec.to_occ_code is not null then
1914: If P_pa_request_rec.to_Occ_Code <>
1915: nvl(p_pos_grp1.occupation_category_code,hr_api.g_varchar2) then