7204: /*- This cursor added for the bug 5840410 --*/
7205:
7206: cursor c1 is
7207: select 'x'
7208: from per_position_extra_info
7209: where position_id= p_position_id
7210: and information_type = 'PER_OVERLAP';
7211:
7212: cursor c2(l_position_id number) is
7210: and information_type = 'PER_OVERLAP';
7211:
7212: cursor c2(l_position_id number) is
7213: select 'x'
7214: from per_position_extra_info
7215: where p_assignment_start_date
7216: between fnd_date.canonical_to_date(poei_information3)
7217: and fnd_date.canonical_to_date(poei_information4)
7218: and position_id= p_position_id -- l_position_id -- for bug 7129787