APPS.PER_KR_EXTRA_AEI_RULES dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 26: from per_assignment_extra_info

22: select 'Y'
23: from dual
24: where not exists(
25: select null
26: from per_assignment_extra_info
27: where assignment_id = p_assignment_id
28: and assignment_extra_info_id <> p_assignment_extra_info_id
29: and information_type = p_information_type
30: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY'));