DBA Data[Home] [Help]

APPS.PQH_SS_UTILITY dependencies on PER_POSITION_STRUCTURES

Line 183: from per_position_structures str, per_pos_structure_versions ver

179: l_pos_structure_version_id number;
180: --
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;