DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on FND_DATE

Line 7216: between fnd_date.canonical_to_date(poei_information3)

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
7219: and information_type = 'PER_OVERLAP';
7220: --

Line 7217: and fnd_date.canonical_to_date(poei_information4)

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
7219: and information_type = 'PER_OVERLAP';
7220: --
7221: begin