APPS.EAM_OPERATIONS_JSP dependencies on BOM_RESOURCES

Line 1779: from cst_activities cst, mtl_uom_conversions muc, bom_resources res, bom_department_resources bdr

1775:
1776: CURSOR c_res_cur IS --rhshriva
1777: select res.resource_code,
1778: res.unit_of_measure
1779: from cst_activities cst, mtl_uom_conversions muc, bom_resources res, bom_department_resources bdr
1780: where nvl(res.disable_date,sysdate+2) > sysdate
1781: and res.resource_id = bdr.resource_id
1782: and res.default_activity_id = cst.activity_id(+)
1783: and (cst.organization_id = res.organization_id or cst.organization_id is null)

Line 2001: from bom_resources

1997: begin
1998:
1999: select resource_id
2000: into l_resource_id
2001: from bom_resources
2002: where resource_code = p_resource_code
2003: and organization_id = p_organization_id;
2004:
2005: exception

Line 4897: FROM bom_department_resources bdr , bom_resources br

4893: -- get resources available in the assigned department
4894: IF(p_resource_code IS NOT NULL) THEN
4895: SELECT bdr.resource_id
4896: INTO l_resource_id
4897: FROM bom_department_resources bdr , bom_resources br
4898: WHERE bdr.department_id = l_department_id
4899: AND bdr.resource_id = br.resource_id
4900: AND br.resource_code like p_resource_code
4901: AND br.organization_id = p_organization_id;