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 151: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;

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