[Home] [Help]
1629: wip_discrete_jobs wdj,
1630: wip_operations wo,
1631: wip_operation_resources wor,
1632: wip_op_resource_instances wori,
1633: bom_resource_employees bre,
1634: (SELECT wip_entity_id,
1635: operation_seq_num,
1636: resource_seq_num,
1637: organization_id,
1685: wip_discrete_jobs wdj,
1686: wip_operations wo,
1687: wip_operation_resources wor,
1688: wip_op_resource_instances wori,
1689: bom_resource_employees bre,
1690: (SELECT wip_entity_id,
1691: operation_seq_num,
1692: resource_seq_num,
1693: organization_id,
1742: wip_discrete_jobs wdj,
1743: wip_operations wo,
1744: wip_operation_resources wor,
1745: wip_op_resource_instances wori,
1746: bom_resource_employees bre,
1747: (SELECT wip_entity_id,
1748: operation_seq_num,
1749: resource_seq_num,
1750: organization_id,
1847: AND ( (p_department_id IS NOT NULL)
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
1924: AND ( (p_department_id IS NOT NULL)
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
2000: AND ( (p_department_id IS NOT NULL)
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
2184:
2185:
2186: select instance_id
2187: into l_instance_id
2188: from bom_resource_employees
2189: where resource_id = p_resource_id
2190: and organization_id = p_organization_id
2191: and person_id = p_employee_id;
2192: