102: --
103: end if;
104: --
105: if p_eligibility_flag = 'Y' then
106: p_eligibility := hr_general.decode_lookup('YES_NO', 'Y');
107: elsif p_eligibility_flag = 'N' then
108: p_eligibility := hr_general.decode_lookup('YES_NO', 'N');
109: else
110: p_eligibility_flag := null;
104: --
105: if p_eligibility_flag = 'Y' then
106: p_eligibility := hr_general.decode_lookup('YES_NO', 'Y');
107: elsif p_eligibility_flag = 'N' then
108: p_eligibility := hr_general.decode_lookup('YES_NO', 'N');
109: else
110: p_eligibility_flag := null;
111: p_eligibility := null;
112: end if;
181: cursor c_pos_struct_ver(p_business_group_id number) is
182: select ver.pos_structure_version_id
183: from per_position_structures str, per_pos_structure_versions ver
184: where str.position_structure_id = ver.position_structure_id
185: and sysdate between ver.date_from and nvl(ver.date_to, hr_general.end_of_time)
186: and str.primary_position_flag = 'Y'
187: and str.business_group_id = p_business_group_id;
188: --
189: BEGIN