DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_POSITION_EXTRA_INFO

Line 7208: from per_position_extra_info

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

Line 7214: from per_position_extra_info

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