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