DBA Data[Home] [Help]

APPS.PQH_SS_UTILITY dependencies on HR_GENERAL

Line 106: p_eligibility := hr_general.decode_lookup('YES_NO', 'Y');

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;

Line 108: p_eligibility := hr_general.decode_lookup('YES_NO', 'N');

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;

Line 185: and sysdate between ver.date_from and nvl(ver.date_to, hr_general.end_of_time)

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