APPS.GHR_EHRI_DYNRPT dependencies on PER_POSITION_EXTRA_INFO

Line 123: l_pos_ei_grp2_data per_position_extra_info%rowtype;

119: FUNCTION exclude_position (p_position_id IN NUMBER
120: ,p_effective_date IN DATE)
121: RETURN BOOLEAN IS
122: --
123: l_pos_ei_grp2_data per_position_extra_info%rowtype;
124: l_position_type VARCHAR2(150);
125: --
126: BEGIN
127: -- first get the Position Type on Position Group 2

Line 154: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;

150: PROCEDURE get_org_comp (p_position_id IN NUMBER
151: ,p_effective_date IN DATE
152: ,p_org_comp OUT NOCOPY VARCHAR2) IS
153: --
154: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
155: BEGIN
156: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
157: ,p_information_type => 'GHR_US_POS_GRP1'
158: ,p_date_effective => p_effective_date

Line 176: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;

172: PROCEDURE get_appr_code (p_position_id IN NUMBER
173: ,p_effective_date IN DATE
174: ,p_appr_code OUT NOCOPY VARCHAR2) IS
175: --
176: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
177: l_appr_code per_position_extra_info.POEI_INFORMATION13%TYPE;
178: BEGIN
179: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
180: ,p_information_type => 'GHR_US_POS_GRP2'

Line 177: l_appr_code per_position_extra_info.POEI_INFORMATION13%TYPE;

173: ,p_effective_date IN DATE
174: ,p_appr_code OUT NOCOPY VARCHAR2) IS
175: --
176: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
177: l_appr_code per_position_extra_info.POEI_INFORMATION13%TYPE;
178: BEGIN
179: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
180: ,p_information_type => 'GHR_US_POS_GRP2'
181: ,p_date_effective => p_effective_date