DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on BOM_DEPT_RES_INSTANCES

Line 1852: bom_dept_res_instances bdri,

1848: OR EXISTS
1849: (
1850: SELECT 1
1851: FROM bom_resource_employees bre,
1852: bom_dept_res_instances bdri,
1853: bom_departments bd
1854: WHERE bre.person_id = p_employee_id
1855: AND bre.effective_start_date <= sysdate
1856: AND bre.effective_end_date >= sysdate

Line 1929: bom_dept_res_instances bdri,

1925: OR EXISTS
1926: (
1927: SELECT 1
1928: FROM bom_resource_employees bre,
1929: bom_dept_res_instances bdri,
1930: bom_departments bd
1931: WHERE bre.person_id = p_employee_id
1932: AND bre.effective_start_date <= sysdate
1933: AND bre.effective_end_date >= sysdate

Line 2005: bom_dept_res_instances bdri,

2001: OR EXISTS
2002: (
2003: SELECT 1
2004: FROM bom_resource_employees bre,
2005: bom_dept_res_instances bdri,
2006: bom_departments bd
2007: WHERE bre.person_id = p_employee_id
2008: AND bre.effective_start_date <= sysdate
2009: AND bre.effective_end_date >= sysdate