120: FUNCTION exclude_position (p_position_id IN NUMBER
121: ,p_effective_date IN DATE)
122: RETURN BOOLEAN IS
123: --
124: l_pos_ei_grp2_data per_position_extra_info%rowtype;
125: l_position_type VARCHAR2(150);
126: --
127: BEGIN
128: -- first get the Position Type on Position Group 2
152: PROCEDURE get_org_comp (p_position_id IN NUMBER
153: ,p_effective_date IN DATE
154: ,p_org_comp OUT NOCOPY VARCHAR2) IS
155: --
156: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
157: BEGIN
158: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
159: ,p_information_type => 'GHR_US_POS_GRP1'
160: ,p_date_effective => p_effective_date
174: PROCEDURE get_appr_code (p_position_id IN NUMBER
175: ,p_effective_date IN DATE
176: ,p_appr_code OUT NOCOPY VARCHAR2) IS
177: --
178: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
179: l_appr_code per_position_extra_info.POEI_INFORMATION13%TYPE;
180: BEGIN
181: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
182: ,p_information_type => 'GHR_US_POS_GRP2'
175: ,p_effective_date IN DATE
176: ,p_appr_code OUT NOCOPY VARCHAR2) IS
177: --
178: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
179: l_appr_code per_position_extra_info.POEI_INFORMATION13%TYPE;
180: BEGIN
181: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
182: ,p_information_type => 'GHR_US_POS_GRP2'
183: ,p_date_effective => p_effective_date