DBA Data[Home] [Help]

APPS.PER_KR_EXTRA_ASSIGNMENT_RULES dependencies on HR_KR_ESTABLISHMENTS_V

Line 13: from hr_kr_establishments_v

9: is
10: l_exists varchar2(1);
11: cursor csr_bp is
12: select 'Y'
13: from hr_kr_establishments_v
14: where organization_id = p_establishment_id
15: and p_effective_date
16: between date_from and nvl(date_to, p_effective_date);
17: begin