DBA Data[Home] [Help]

APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on BOM_RESOURCES

Line 449: FROM bom_resources

445: IF p_organization_id IS NULL OR p_resource_id IS NULL THEN
446: RETURN NULL;
447: ELSE
448: SELECT resource_code INTO l_resource_code
449: FROM bom_resources
450: WHERE organization_id = p_organization_id
451: and resource_id = p_resource_id
452: and (disable_date IS NULL
453: or disable_date > sysdate);