1847: OR EXISTS
1848: (
1849: SELECT 1
1850: FROM bom_resource_employees bre,
1851: bom_dept_res_instances bdri,
1852: bom_departments bd
1853: WHERE bre.person_id = p_employee_id
1854: AND bre.effective_start_date <= sysdate
1855: AND bre.effective_end_date >= sysdate
1924: OR EXISTS
1925: (
1926: SELECT 1
1927: FROM bom_resource_employees bre,
1928: bom_dept_res_instances bdri,
1929: bom_departments bd
1930: WHERE bre.person_id = p_employee_id
1931: AND bre.effective_start_date <= sysdate
1932: AND bre.effective_end_date >= sysdate
2000: OR EXISTS
2001: (
2002: SELECT 1
2003: FROM bom_resource_employees bre,
2004: bom_dept_res_instances bdri,
2005: bom_departments bd
2006: WHERE bre.person_id = p_employee_id
2007: AND bre.effective_start_date <= sysdate
2008: AND bre.effective_end_date >= sysdate