APPS.PER_ASSIGNMENTS_F_PKG dependencies on FND_DATE

Line 1945: and fnd_date.canonical_to_date(aei_information1) = p_promotion_date;

1941: select assignment_extra_info_id, object_version_number
1942: from per_assignment_extra_info
1943: where assignment_id = p_assignment_id
1944: and information_type = 'PROMOTION'
1945: and fnd_date.canonical_to_date(aei_information1) = p_promotion_date;
1946: --
1947: l_promotion_rec c_promotion_exists%rowtype;
1948: l_assignment_extra_info_id number;
1949: l_object_version_number number;