APPS.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 364: from per_assignment_extra_info aei

360: and pei.information_type = 'NL_DS_SICK_INFO';
361:
362: cursor cur_get_tml_info( l_assignment_id number, l_effective_date date) is
363: select aei.aei_INFORMATION3
364: from per_assignment_extra_info aei
365: where aei.assignment_id = l_assignment_id
366: AND aei_information_category = 'NL_TML'
367: and l_effective_date between fnd_date.canonical_to_date(aei_information1) and
368: NVL(fnd_date.canonical_to_date(aei_information2), to_date('31-12-4712','DD-MM-YYYY'));