DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_CRITERIA dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 240: from per_pos_structure_elements a

236:
237:
238: cursor c_pos_hier is
239: select 'x'
240: from per_pos_structure_elements a
241: where a.POS_STRUCTURE_VERSION_ID = p_pos_structure_version_id
242: and a.business_group_id = p_business_group_id
243: and (a.parent_position_id = p_position_id
244: or a.subordinate_position_id = p_position_id)

Line 254: from per_pos_structure_elements a

250: -- this cursor make sure the validation
251: -- since it is user defined values
252: cursor c_pos is
253: select 'x'
254: from per_pos_structure_elements a
255: where a.subordinate_position_id = p_position_id
256: and a.subordinate_position_id = p_start_position_id
257: and a.business_group_id = p_business_group_id
258: and a.POS_STRUCTURE_VERSION_ID = p_pos_structure_version_id