DBA Data[Home] [Help]

APPS.GHR_CPDF_DYNRPT dependencies on PER_POSITION_EXTRA_INFO

Line 119: l_pos_ei_grp2_data per_position_extra_info%rowtype;

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

Line 150: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;

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